6. I must be missing something

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
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


Two, select&copy your code
Then use the Reset Code button of the course-window,
then paste your code back in.

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

present the code you are using…
and the instructions to which you wrote the code…

Your code is Ok.
But try to use the code writing

SELECT origin, id,
    FROM flights f
        WHERE f.id < flights.id
          AND f.origin=flights.origin) + 1 
           AS flight_sequence_number
FROM flights;

Then try
leaving the codecademy course
remove all cooky files
log-into the codecademy course and try again…