Table transformation: lesson I 6/7 answer to the exercise


#1

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;


Replace this line with your code.


#2

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