Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
15. Status of Flight Tickets
On this page

Problem

Table: Flights

+-------------+------+
| Column Name | Type |
+-------------+------+
| flight_id   | int  |
| capacity    | int  |
+-------------+------+
flight_id column contains distinct values.
Each row of this table contains flight id and capacity.

Table: Passengers

+--------------+----------+
| Column Name  | Type     |
+--------------+----------+
| passenger_id | int      |
| flight_id    | int      |
| booking_time | datetime |
+--------------+----------+
passenger_id column contains distinct values.
booking_time column contains distinct values.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page