I am totally lost in the first lesson


Replace this line with your code.


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


select count(distinct id) from flights;

Here, they're asking us to count those flights which are representing the flights table, which means we need to give a count of different flights. Hope this helps.


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