How many customers are there?
select count ( * ) from customers
How many orders each customer have?
select customer_id, count ( * ) from orders group by customer_id
Can you provide me with the list of id and status of orders of the customer named "Jeramie"?
select t2.order_id, t2.order_status from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Jeramie"