Purchases Without Internal Details

QUERY is preparing a compact purchase export for the station report. Keep only purchase events from events and return every column except items, session, and is_paid; exclude those fields from * instead of listing the remaining columns manually. Sort by event_id.

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.

event_id	user_id	event_name	platform	city	event_ts	revenue
3	101	purchase	ios	Murmansk	1773479740.000000	1290
7	103	purchase	web	Miausino	1773576360.000000	4300
10	104	purchase	ios	Murmansk	1773600000.000000	890

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid