Any customer named Jeramie?
select * from customers where customer_name = "Jeramie"
Show me the status of his orders
select t2.order_status from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Jeramie"
Show me the id's of his orders as well.
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"