address.sql

SELECT * FROM finalproject.address;
describe address;

INSERT INTO address VALUES('CSal','7C','smith street','Boston','MA',02120);
INSERT INTO address VALUES('SDel','Round Rock','RR','Texas','TX',02512);
INSERT INTO address VALUES('CChi','10G','Atlantic Stn','Stamford','CT',06910);
INSERT INTO address VALUES('SHp','6M','Hordan Street','Syracuse','NY',02920);
INSERT INTO address VALUES('CApo','443','Tresser Street','Hatford','CT',05432);
INSERT INTO address VALUES('SLen','9L','McGreevey','Arizona','NY',02821);
INSERT INTO address VALUES('CGee','5B','Kurar','Maryland','CA',06720);
INSERT INTO address VALUES('SMac','98T','George St','Vegas','CH',05438);

INSERT INTO address VALUES('Cell','7C','smith street','Boston','MA',02120);
INSERT INTO address VALUES('Shel','Round Rock','RR','Texas','TX',02512);
INSERT INTO address VALUES('Chhi','10G','Atlantic Stn','Stamford','CT',06910);
INSERT INTO address VALUES('Skp','6M','Hordan Street','Syracuse','NY',02920);
INSERT INTO address VALUES('Cipo','443','Tresser Street','Hatford','CT',05432);
INSERT INTO address VALUES('llen','9L','McGreevey','Arizona','NY',02821);
INSERT INTO address VALUES('CGke','5B','Kurar','Maryland','CA',06720);
INSERT INTO address VALUES('tSac','98T','George St','Vegas','CH',05438);

INSERT INTO address VALUES('kSal','7C','smith street','Boston','MA',02120);
INSERT INTO address VALUES('pDel','Round Rock','RR','Texas','TX',02512);
INSERT INTO address VALUES('hChi','10G','Atlantic Stn','Stamford','CT',06910);
INSERT INTO address VALUES('SHi','6M','Hordan Street','Syracuse','NY',02920);
INSERT INTO address VALUES('CAoo','443','Tresser Street','Hatford','CT',05432);
INSERT INTO address VALUES('SLkn','9L','McGreevey','Arizona','NY',02821);
INSERT INTO address VALUES('CGre','5B','Kurar','Maryland','CA',06720);
INSERT INTO address VALUES('Sdac','98T','George St','Vegas','CH',05438);
INSERT INTO address VALUES('hMac','98T','George St','Vegas','CH',05438);