Which Platform Converts Best

QUERY is comparing platforms before reconstructing Kotomarket’s old funnel. For each platform, calculate the share of paid events among all events: count paid rows using the is_paid condition and perform safe division so a zero denominator produces NULL.

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. Your answer must use the same column names as this sample — alias them with AS if needed.

platform	cr
android	0.25
ios	0.3333333333333333
web	0.5

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid