One Row per Item

One Row per Item

L. wants to analyze products individually, but each basket is stored as an array in the event log. From events, return event_id and item, with one row for every element of items; omit events that contain no items. Sort by event_id, then by item.

Any row order

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid