which order has high quantity
select order_id, from order_items group by order_id order by sum ( order_quantity ) desc limit 1
how many types of products have rodrick heaney bought in total?
select count ( distinct t3.product_id ) from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id where t1.customer_name = "Rodrick Heaney"
I want everything about it.
select * from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id group by t2.customer_id order by sum ( t3.order_quantity ) desc limit 1