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"
list of id and status of orders refers to selecting order_id and order_status; of the customer named \"Jeramie\" refers to filtering the records where customer_name = \"Jeramie\"; JOIN is used to combine customers and orders tables on customer_id.