Which customers have ordered "food"? | ok, did you want to just return their names? | Yes. I just want to know the names of which customers have placed orders under the category "food"
SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 JOIN order_items AS T3 JOIN products AS T4 ON T1.customer_id  =  T2.customer_id AND T2.order_id  =  T3.order_id AND T3.product_id  =  T4.product_id WHERE T4.product_name  =  "food"
customers who have ordered 'food' refers to a JOIN between customers, orders, order_items, and products tables with a condition on product_name = 'food'; returning their names refers to SELECT customer_name.