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"
How many customers placed orders before George?
select count ( t1.customer_name ) from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.date_order_placed < ( select t2.date_order_placed from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t1.customer_name = 'George' order by t2.date_order_placed limit 1 )
What is the status of George's order?
select t2.order_status from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t1.customer_name = 'George'