A Leaner Event Log

The product and session fields make L.’s quick export unnecessarily heavy. Return every column from events except items and session, selecting the remaining columns together rather than listing them manually. Sort the result 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	is_paid
1	101	app_open	ios	Murmansk	1773479520.000000	NULL	false
2	101	product_view	ios	Murmansk	1773479590.000000	NULL	false
3	101	purchase	ios	Murmansk	1773479740.000000	1290	true

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid