Paid Events Across Cities
Paid Events Across Cities
L. is preparing a city-level summary to see where payments were recorded most often. For each city, count the rows in events where is_paid is true, using a counter that operates on a Boolean condition.
Output city and the number of such events as paid. Sort the result by city.
Any row order
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid