• KX Academy

  Fundamentals Capstone 5.2 format test fail.

  Posted by Kenan on April 2, 2024 at 7:35 pm

  I’m having an issue witht the format for 5.2, my code for 5.1 and 5.3 pass… I attached a copy of my code and the schema for edgeProfile.

  edgeProfile: select numTrds: count i, avgEdge: avg edge, minQty: min qty, maxQty: max qty by option_id from trade where date = last date, edge > avg edge

  

  Laura replied 7 months, 1 week ago 3 Members · 3 Replies
• 3 Replies

• 

  Kenan

  Member

  April 3, 2024 at 7:19 am

  I found why my test was failing. Thank you

• 

  Kal8na

  Member

  April 13, 2024 at 6:56 am

  I’m getting the same error can you explain what is wrong here please?

• 

  Laura

  Administrator

  April 15, 2024 at 4:22 pm

  Hi @kal8na,

  I’m not sure without looking at your code, but for 5.2 you will need to ensure you are using fby or similar. You can watch this video to get a better idea of how to approach this: Fby Vs. Nested Queries – KX Learning Hub

  Hope this helps,

  Laura

Log In to Reply