What are the order IDs that have those product IDs?
select T2.order_id from Products as T1 join Order_Items as T2 where T1.product_id  =  T2.product_id and T1.product_name  =  'food'
order IDs that have those product IDs refers to a join condition on product_id from two tables (Products and Order_Items) where product_name is 'food';