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(values1,values2);

alter statement-

ALTER TABLE table_name

ADD column_name data;