6. I must be missing something

Get Help SQL
#1

I am using the exact same code, but it will not pass. I must be missing something.

6. Correlated Subqueries II
#2

@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&copy 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

#5

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

#7

@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;
#9

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

#11