Mock interview. You're interviewing for a business analyst job on a home-sharing marketplace's city teams. The interviewer says: "New York listings earn far more than Lisbon ones. The Lisbon team wants to know if they're doing something wrong. Can you explain the gap?"
Use confirmed bookings with a checkin_date in Q1 2026 (January to March). Count every listing in a city, including listings with no bookings.
"Show each city's listings, Q1 revenue, and revenue per listing."
Expected output
Return: city, listings, revenue and revenue per listing (name the columns however you like)
city, listings, revenue, revenue_per_listing (rounded to 2 decimals); sorted by revenue_per_listing, highest firstExample of the shape (made-up values):
| city | listings | revenue | revenue_per_listing |
|---|---|---|---|
| Rome | 60 | 42000.00 | 700.00 |
Step 1 of 3
Write your query here. Ctrl + Enter submits.