vivid_vole_7847

One barrier on a single table: profit per region

In-stock products, single stage

Count in-stock products per category

Select the names of in-stock products

Not every payload has a currency field (only some purchases do)

Purchase payloads contain an items array, each item an object with sku and qty

The tags column is a JSON array of strings

For button_click events, the payload has a nested position object with x and y

The event_data table has a JSON payload column

Calculate the per-unit price by dividing total_amount by quantity