select replace(p.product_name,'"') product
, to_char(o.order_timestamp, 'YYYY')||'W'||to_char(o.order_timestamp, 'iW') quarter
, i.unit_price * i.quantity unitprice
, p.category
from demo_order_items i
, demo_orders o
, demo_product_info p
where i.order_id = o.order_id
and i.product_id = p.product_id