SELECT T1.order_id FROM orders AS T1 JOIN order_items AS T2 ON T1.order_id = T2.order_id GROUP BY T1.order_id ORDER BY count(*) DESC LIMIT 1
What is the id of the order which has the most items?
SELECT T1.order_id FROM orders AS T1 JOIN order_items AS T2 ON T1.order_id = T2.order_id GROUP BY T1.order_id ORDER BY count ( * ) DESC LIMIT 1
select t1 . order_id from orders as t1 join order_items as t2 on t1 . order_id = t2 . order_id group by t1 . order_id order by count ( * ) desc limit value
What is the id of the order which has the most items ?