Can you give me a list of all products?
select * from products
large to small
select * from order_items as t1 join products as t2 on t1.product_id = t2.product_id group by t1.product_id order by sum ( order_quantity ) desc