As an analyst at Airbnb, one of the most useful insights you could provide would be to understand the average number of guests per booking across locations. For this question, we would like you to write a SQL query that will find the average number of guests per booking in each city. bookings **Example Input:** booking_id property_id guests booking_date ------------------------------------------------ 101 4523 3 01/01/2022 102 9871 2 01/05/2022 103 4523 4 02/10/2022 104 7452 1 02/20/2022 105 9871 3 03/01/2022 properties **Example Input:** property_id city ------------------------- 4523 New York 9871 Los Angeles 7452 Chicago **Example Output:** city average_guests ----------------------------- New York 3.5 Los Angeles 2.5 Chicago 1.0 **Answer:** SELECT p.city, AVG(b.guests) AS average_guests FROM bookings b JOIN properties p USING(property_id) GROUP BY 1 ---