Project 1

1a)select cust_city,no_of_orders from customer order by no_of_orders;

2a)alter table product rename column product_id to prod_id;
alter table product rename column prodct_name to prod_name;
alter table product rename column product_type to prod_type;
alter table product rename column product_price to prod_price;
alter table product rename column product_review to prod_review;
alter table product rename column product_warrenty to prod_warrenty;
alter table product rename column product_coupon to prod_coupon;
alter table product rename column product_discount to prod_discount;

3a)select * from customer where no_of_orders >=1;

4a)SELECT * FROM customer WHERE cust_name LIKE "%A" and cust_name LIKE "A%" AND no_of_orders >1;

5a)select * from orders where order_price > 10000 and order_status ="delivered" and product.prod_no_of_customer > 1 ;

6a)DELIMITER $$
CREATE PROCEDURE Getcustomer()
BEGIN
SELECT * FROM customer;
END$$
DELIMITER ;
call Getcustomer();