Concert Attendance Analysis
Finance needs attendance broken down per tour leg — it feeds into royalty calculations. For each tour output its id, departure and arrival cities, and the fan count, sorted by attendance descending.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| fans | tour_id | town_to | town_from |
|---|---|---|---|
| 4 | 1 | London | Moscow |
| 3 | 2 | Paris | Moscow |
| 2 | 3 | New York | London |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in