🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 149:

List of No-Show Passengers

PostgreSQL
Get a list of passengers who bought a ticket for flight 15175 (flight_id = 15175) and did not board.
Output the result in the form of a table with columns passenger_id, passenger_name and contact_data  - contact passenger data sorted by passenger name.
Expected result Columns: 3 · Rows: 15
passenger_id passenger_name contact_data

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query