I am using the exact same code, but it will not pass. I must be missing something.
have you tried a refresh Browser
++++ reset of session *****************
under certain circumstances you can shoot your Browser in an
Therefor it is of an advantage to know that you have 2 reset facilities:
One is the use of the F5-key which does a refresh Browser
Two, select© your code
Then use the Reset Code button of the course-window,
then paste your code back in.
Always refresh the browser after making corrections:
CTRL f5 ( if on Windows or Linux)
CMD r ( if on a MAC).
CTRL 0 to reset browser zoom
Resetting the exercise, gives me a "Something went wrong" message. I am going to try this out in IE.
I'm never going to pass this course. LOL!
present the code you are using...
and the instructions to which you wrote the code...
SELECT origin, id,
FROM flights f
WHERE f.id < flights.id
AND f.origin=flights.origin) + 1 AS flight_sequence_number
Your code is Ok.
But try to use the code writing
SELECT origin, id, (SELECT COUNT(*) FROM flights f WHERE f.id < flights.id AND f.origin=flights.origin) + 1 AS flight_sequence_number FROM flights;
No dice .. I get the same error.
Find the origin, flight id, and sequence number.
leaving the codecademy course
remove all cooky files
log-into the codecademy course and try again...
Funny thing. I needed to type the sql statement without adding returns and tabs to make it pretty. It finally passed.