(6/7) Help me please!


#1


https://www.codecademy.com/courses/sql-table-transformation/lessons/subqueries/exercises/correlated-ii?action=lesson_resume


Not getting any error messages, but I am still getting the correct data from the query.


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



#2

DISREGARD, IT SAID I WAS WRONG BECAUSE OF ONE SPACE. now going to go kms...


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.