Hi! Could we please enable some services and cookies to improve your experience and our website?
Privacy & Cookie Policy.Greetings, SQL lovers!
I am writing to you today because I need your help.
SQLtest.online is a free platform designed to help people of all levels master SQL.How you can help:
The more people use the platform, the better it will become. We'll be able to add more content, improve features, and create a better community for SQL enthusiasts.
Thanks for your help!
Command SQLtest.online
Using the solution of the previous problem rank airports by the number of delayed flights in August 2017 (the fewer the better). Only include airports with more than 100 departures per month. Output the result as a table with columns: airport_rank - airport rating, airport_name - English name of the airport delayed_flights_rate - percentage of delayed flights accurate to two digits. Sort the table by rating
Use PostgreSQL syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.ER diagram of the Bookings database
aircraft_code | model | range | |
---|---|---|---|
1 | 773 | {"en": "Boeing 777-300", "ru": "Боинг 777-300"} | 11100 |
airport_code | airport_name | city | coordinates | timezone | |
---|---|---|---|---|---|
1 | YKS | {"en": "Yakutsk Airport", "ru": "Якутск"} | {"en": "Yakutsk", "ru": "Якутск"} | (129.77099609375,62.0932998657227) | Asia/Yakutsk |
ticket_no | flight_id | boarding_no | seat_no | |
---|---|---|---|---|
1 | 0005435212351 | 30625 | 1 | 2D |
book_ref | book_date | total_amount | |
---|---|---|---|
1 | 00000F | 2017-07-05 00:12:00+00 | 265700.00 |
flight_id | flight_no | scheduled_departure | scheduled_arrival | departure_airport | arrival_airport | status | aircraft_code | actual_departure | actual_arrival | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1185 | PG0134 | 2017-09-10 06:50:00+00 | 2017-09-10 11:55:00+00 | DME | BTK | Scheduled | 319 |
aircraft_code | seat_no | fare_conditions | |
---|---|---|---|
1 | 319 | 2A | Business |
ticket_no | flight_id | fare_conditions | amount | |
---|---|---|---|---|
1 | 0005432159776 | 30625 | Business | 42100.00 |
ticket_no | book_ref | passenger_id | passenger_name | contact_data | |
---|---|---|---|---|---|
1 | 0005432000987 | 06B046 | 8149 604011 | VALERIY TIKHONOV | {"phone": "+70127117011"} |