CREATE TABLE Shipment_Items (shipment_id NUMBER, order_item_id NUMBER)
CREATE TABLE Products (product_id NUMBER, product_name VARCHAR2, product_details VARCHAR2)
CREATE TABLE Order_Items (order_item_id NUMBER, product_id NUMBER, order_id NUMBER, order_item_status VARCHAR2, order_item_details VARCHAR2)
CREATE TABLE Shipments (shipment_id NUMBER, order_id NUMBER, invoice_number NUMBER, shipment_tracking_number VARCHAR2, shipment_date DATETIME, other_shipment_details VARCHAR2)
CREATE TABLE Invoices (invoice_number NUMBER, invoice_date DATETIME, invoice_details VARCHAR2)
CREATE TABLE Orders (order_id NUMBER, customer_id NUMBER, order_status VARCHAR2, date_order_placed DATETIME, order_details VARCHAR2)
CREATE TABLE Customers (customer_id NUMBER, customer_name VARCHAR2, customer_details VARCHAR2)

Find the status of orders which belong to the customer named 'Jeramie', group by order status, and show the proportion of order status with a pie chart.
SELECT T2.order_status, COUNT(T2.order_status) FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id = T2.customer_id WHERE T1.customer_name = "Jeramie" GROUP BY order_status
SELECT "T2"."order_status", COUNT("T2"."order_status") FROM "Customers" "T1" JOIN "Orders" "T2" ON "T1"."customer_id" = "T2"."customer_id" WHERE "Jeramie" = "T1"."customer_name" GROUP BY "order_status"