Which customers made at least two orders?
select *, count ( * ) from orders as t1 join customers as t2 on t1.customer_id = t2.customer_id group by t2.customer_id having count ( * ) > = 2
How many orders did George make?
select count ( * ) from orders as t1 join customers as t2 on t1.customer_id = t2.customer_id where t2.customer_name = "George"
How many did Beulah make?
select count ( * ) from orders as t1 join customers as t2 on t1.customer_id = t2.customer_id where t2.customer_name = "Beulah"