Show all the order items.
select * from order_items
Show the number of times each product was ordered.
select count(*) from order_items group by product_id
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