Project 1

1) select Customer_id, city, pincode from Customer;

2) alter table product
rename column product_id to Prod_Product_id,
rename column Type to prod_Type,
rename column Color to prod_Color,
rename column P_Size to prod_P_Size,
rename column Gender to prod_Gender,
rename column Commission to prod_Commission,
rename column Cost to prod_Cost,
rename column Quantity to prod_Quantity,
rename column Seller_id to prod_Seller_id;

3) select Order_id from Order;

4) select Name,
from Order
where Name between A and A
group by Customer_id;

5) select * from Order where 10000 (SELECT AVG(9000) from Orders;