Hierarchical JSON Aggregation with Conditional Flattening

A table orders(id, payload VARCHAR) stores a JSON document per order, e.g.: Produce a result set with one row per order‑item, containing: | order_id | customer | sku | total_price | region | channel | total_price = price * qty. Only include items where total_price > 25 USD.

These are the tables to query for this question:

bootcamp.quiz_orders_json

Your answer should include these columns:

order_id integer
customer varchar
sku varchar
total_price double
region varchar
channel varchar

Querying is only for logged in users!

Query Results