How many total orders do we have?
select count ( * ) from orders
What is the total number of customers?
select count ( * ) from customers
What are their customer id's?
select customer_id from customers
What was the amount of orders for the customer that had that most orders?
select count ( * ) from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id group by t1.customer_id order by count ( * ) desc limit 1
Which customer had 3 orders?
select * from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id group by t1.customer_id having count ( * ) = 3
What is the customer id for George?
select customer_id from customers where customer_name = "George"
And for Jeramie?
select customer_id from customers where customer_name = "Jeramie"