I am using the exact same code, but it will not pass. I must be missing something.
@williamparker
have you tried a refresh Browser
++++ reset of session *****************
under certain circumstances you can shoot your Browser in an
inconsistent state.
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
and
Two, select© your code
Then use the Reset Code button of the course-window,
then paste your code back in.
Addendum
General Notes:
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
@williamparker
present the code you are using…
and the instructions to which you wrote the code…
@william_parker,
Your code is Ok.
But try to use the code writing
like
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;
@william_parker
Then try
leaving the codecademy course
remove all cooky files
log-into the codecademy course and try again…