Database: department_store
Question: What is the id of the product that was ordered the most often?
SQL:
SELECT product_id FROM order_items GROUP BY product_id ORDER BY count(*) DESC LIMIT 1