Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.

Correlated Subqueries II

It would also be interesting to order flights by giving them a sequence number based on time, by carrier.

For instance, assuming flight_id increments with each additional flight, we could use the following query to view flights by carrier, flight id, and sequence number:

SELECT carrier, id, (SELECT COUNT(*) FROM flights f WHERE < AND f.carrier=flights.carrier) + 1 AS flight_sequence_number FROM flights;
Report a Bug
If you see a bug or any other issue with this page, please report it here.