Project 1

1)customer in the order of their city

SELECT customer FROM customer_table

GROUP BY city;

2.alter table product by renaming vall the columns

ALTER TABLE product RENAME id TO prod _id, name to prod _name;

3.to fetch the details of customer who purchased atleast one product

SELECT customer_name FROM customer

WHERE purchase >1

GROUP BY customer_id;

4.to fetch the details of customer who name starts with A and end with A and purchased more than one product

SELECT customer_name FROM customer

WHERE customer_name LIKE A, purchase ›1

GROUP BY customer_id;

6.simple procedure to run all the table creation, insert statement and alter statement

table creation-

CREATE TABLE table _name;

insert statement-

INSERT INTO table VALUES (values,values2);

alter statement-

ALTER TABLE table_name

ADD column_name data;