SELECT product_id FROM order_items GROUP BY product_id ORDER BY count(*) DESC LIMIT 1
Give the product id for the product that was ordered most frequently.
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
Give the product id for the product that was ordered most frequently .