CREATE TABLE ORDERS ( ORDER_ID NUMBER NOT NULL PRIMARY KEY, CUST_ID NUMBER NOT NULL, PRICE NUMBER NOT NULL, NUM_ITEMS NUMBER NOT NULL); CREATE TABLE WEB_CUSTOMERS ( CUST_ID NUMBER NOT NULL PRIMARY KEY, NAME VARCHAR2(15) NOT NULL, ADDRESS VARCHAR2(16) NOT NULL); CREATE TABLE seller_feedback ( ORDER_ID NUMBER NOT NULL PRIMARY KEY, RATING NUMBER, REVIEW VARCHAR2(23));

INSERT INTO ORDERS VALUES (0,0,12,2); INSERT INTO ORDERS VALUES (1,0,89,4); INSERT INTO ORDERS VALUES (2,1,139,7); INSERT INTO ORDERS VALUES (3,1,201,4); INSERT INTO ORDERS VALUES (4,2,235,8); INSERT INTO ORDERS VALUES (5,0,21,1); INSERT INTO ORDERS VALUES (6,3,1099,31); INSERT INTO ORDERS VALUES (7,3,1197,3); INSERT INTO WEB_CUSTOMERS VALUES (0,'Viggo Mortensen', '1 CampusDr 49401'); INSERT INTO WEB_CUSTOMERS VALUES (1,'Clint Eastwood', '12 Main 49426'); INSERT INTO WEB_CUSTOMERS VALUES (2,'Simon Pegg', '1980 20th 49428'); INSERT INTO WEB_CUSTOMERS VALUES (3,'Liam Neeson', '2870 8th 49424'); INSERT INTO seller_feedback VALUES (0,10,'Items were great!'); INSERT INTO seller_feedback VALUES (3,7,'Shipping took too long'); INSERT INTO seller_feedback VALUES (4,2,'Not what I ordered!'); INSERT INTO seller_feedback VALUES (5,6,'Arrived late, Bruh!');

Using the WEB_CUSTOMERS, ORDERS, and seller_feedback tables, provide the SQL statement needed to query/find the list of customer names who had at least one order over $200. If a customer has placed multiple large orders, you can choose to print their name only once or else multiple times.

Provide the SQL statement needed to query/find the total overall amount of money that has been spent by each customer (adding up the total price of all of their multiple orders).

Provide the SQL statement needed to query/find ALL order records and attributes from the ORDERS table and (if that order is also found in the seller_feedback table) will also add/append the rating for that order.