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

Aircraft Seat Map

PostgreSQL
Retrieve the seat map for the Boeing 777-300.
Display a table with fields:
- row - row number,
- seats - JSON array with seat numbers sorted alphabetically (["A", " B", "C", "H", "J", "K"] ),
- fare_conditions - place type.
Expected result Columns: 3 · Rows: 46
row seats fare_conditions

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