6. I must be missing something


#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


#3

Resetting the exercise, gives me a "Something went wrong" message. I am going to try this out in IE.


#4

I'm never going to pass this course. LOL!


#5

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


#6

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;


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

#8

No dice .. I get the same error.

Find the origin, flight id, and sequence number.


#9

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


#10

Funny thing. I needed to type the sql statement without adding returns and tabs to make it pretty. It finally passed.


#11