As an Airbnb data analyst, you have been asked to analyze the performance of hosts' listings in the past year. Your task is to **identify the top 10 listings with the most bookings.** There are two tables involved. One is the 'hosts' table that provides details about each host and its respective listing. The other one is 'bookings' table that records each booking transaction. hosts **Example Input:** host_id listing_id listing_name city --------------------------------------------- 101 201 Penthouse New York 102 202 Ocean View San Francisco 103 203 Country House Austin bookings **Example Input:** booking_id user_id listing_id booking_date ----------------------------------------------- 301 401 201 06/08/2022 302 402 202 06/10/2022 303 403 202 07/10/2022 304 404 203 08/08/2022 305 405 201 09/08/2022 Remarks: Both tables can be joined on the 'listing_id' field. **Answer:** SELECT listing_id, listing_name, COUNT(booking_id) AS number_of_bookings FROM hosts h LEFT JOIN bookings b USING(listing_id) GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 10; ---