Project 1

Task 3:

1) Select customer AS cust_id FROM WHERE order AS ord_city;

2) Alter table new name Product to ' prod'_'name';

Alter table new name Product to ' prod'_'colur;;

Alter table new name Product to ' prod'_'seller';

Alter table new name Product to ' prod'_'sizes_avag';

Alter table new name Product to ' prod'_'quantity_avag';

3) Select Customer From Cust_id Where Prod_id =>1;

4) SELECT FROM orders A WHERE purch_amt > (SELECT AVG(purch_amt) FROM orders A WHERE b.customer_id = a.customer_id);

5) Select FROM order AS ord_id WHERE 10000>1;

6) USE dbmswrkshop;

Customer as a Cust_Id (Primary KEY ) int,

Customer Name (Cust_fname) VARCHAR 50,

Customer Lastname (Cust_lname) VARCAHR 50,

Customer_ID (Primary KEY );

SELECT * FROM STATEMENT