Find the distribution of flights from Moscow to St. Petersburg by day of the week. Display the result in three columns: day_of_week - day of the week in English (Sunday - Saturday), flights - number of flights on this day according to the schedule (scheduled_arrival), passengers - number of passengers according to the boarding_passes table. Sort the table by day of the week from Monday to Sunday.
Write your request in the field below and click the "Check it!" button.
Use PostgreSQL syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.
ER diagram of the Bookings database
