Your objective is to extract data from the airports_data table. Specifically, retrieve the airport_code along with a JSON object that includes the city name in English (from the city column) and the airport name in English (from the airport_name column). The output should have two columns: airport_code and airport_data, formatted as follows: {"city": "Yakutia", "name": "Polyarny Airport"}.
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
