Level 7 - ArchitectQuery-Based Questionsm2 query shape optimization
Shape Query for Top Categories by Revenue
Return top 10 categories by paid revenue in last quarter with category_id and revenue.
Schema Context
orders(order_id, status, paid_at), order_items(order_id, category_id, amount)