🙏 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 53:

Airports with one-way departures

PostgreSQL
Find airports from which you can fly in only one direction.
Create the resulting table with columns: departure_airport, departure_city - name and city of departure airport (in English), arrival_airport and arrival_city name and city of the destination airport (in English). Sort the result by the departure_city column.
Expected result Columns: 4 · Rows: 7
departure_airport departure_city arrival_airport arrival_city

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