-
Fundamentals Capstone 5.2 format test fail.
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
-
3 Replies
-
I found why my test was failing. Thank you
-
I’m getting the same error can you explain what is wrong here please?
-
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.