Platforms That Saw a Payment

After the outage, QUERY checks whether the checkout came back to life at least once on each platform.

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	had_purchase
android	true
ios	true
web	true

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid