Can you tell me which customers placed orders between 2009-01-01 and 2010-0101? | do you want the id or the name of the customer? | The names
SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id  =  T2.customer_id WHERE T2.date_order_placed  > =   "2009-01-01" AND T2.date_order_placed < =  "2010-01-01"
customers who placed orders between two dates refers to filtering orders with date_order_placed >= '2009-01-01' AND date_order_placed <= '2010-01-01'; want the names of the customers refers to selecting customer_name; joining customers and orders tables on customer_id to get customer names for orders placed within the given date range.