SELECT product_id FROM order_items GROUP BY product_id ORDER BY count(*) DESC LIMIT 1
What is the id of the product that was ordered the most often?
SELECT product_id FROM order_items GROUP BY product_id ORDER BY count ( * ) DESC LIMIT 1
select product_id from order_items group by product_id order by count ( * ) desc limit value
What is the id of the product that was ordered the most often ?