Yes please.
select product_details, product_id from products
Yes.
select t1.product_details,t2.order_quantity from products as t1 join order_items as t2 on t1.product_id = t2.product_id
Can you tell which product has been ordered the most number of times?
select t2.product_details from order_items as t1 join products as t2 on t1.product_id = t2.product_id group by t1.product_id order by count ( * ) desc limit 1