customers table, Sql Server

customers table

create table customers(                  
                       PRODUCT_ID INT NOT NULL,
                       PRODUCT_NAME VARCHAR(20),
                       NAME VARCHAR(10) NOT NULL,
                       ADDRESS VARCHAR(20),
                       PRIMARY KEY (PRODUCT_ID, PRODUCT_NAME)
                       );
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (1, 'Mugs', 'Deekshitha', 'vishakapatnam');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (2, 'vases', 'shabbu', 'vishakapatnam');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (3, 'Mugs', 'lasya', 'hyderabad');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (4, 'Mugs', 'sohel', 'vishakapatnam');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (5, 'boxes', 'mehaboob', 'karimnagar');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (6, 'Mugs', 'sujatha', 'vishakapatnam');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (7, 'boxes', 'monal', 'warangal');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (8, 'Mugs', 'akhil', 'vijayawada');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (9, 'vases', 'abhijeeth', 'guntur');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (10, 'plant holder', 'priya', 'vishakapatnam');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (11, 'mugs', 'shiva', 'warangal');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (12, 'Mugs', 'rajashekar', 'guntur');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (13, 'boxes', 'divi', 'hyderabad');
INSERT INTO CUSTOMERS (PRODUCT_ID, PRODUCT_NAME, NAME, ADDRESS) VALUES (14, 'Mugs', 'Devi', 'vijayawada');

SELECT * FROM CUSTOMERS;


run \| edit \| history \| help	0