-
Fundamentals Capstone 3.1, 4.4, 4.5 and 5.3
I have been working on the as-of-join table…all of the other exercises passed the tests, but this one has not (screenshot attached). I also do not understand if this error would further propagate for exercises 4.4 and 4.5 or not, as they also fail the test, even if the returnN function from 4.3 has passed the test. Moreover, would the error from 3.1 have anything to do with the tests failed for 5.3?
Apologies for the very long thread, I am putting all these exercises together because I do not know if these errors all stem from 3.1 or not (screenshots for 3.1, 4.4, 4.5, 5.3 are attached)
-
1 Reply
-
Hi ,
Thanks for sending all the screenshots. I can see that your errors are unrelated.
3.1: You don’t need to sort on option_id, and only nbbodata needs to be sorted on time.
4.4 and 4.5: both top5EdgeTimes and bottom5QtyTimes are expected to be tables, so if you remove your “select minute from” in both cases, these tests should pass.
5.3: Double check your code for keying edgeProfileFull – there is a typo in your table name.
Hope this helps!
Laura
Log in to reply.