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

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid