Row counts by status code (ClickHouse)

Row counts by status code (ClickHouse)

From table logs, count the number of rows cnt for each status_code. Output columns status_code, cnt. Order by status_code.

Expected output sample

status_codecnt
2005
4042
5002
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid