Class work
1. Create Customers
1. Create the following table
2. Please ensure that any previous table is dropped first to prevent any conflicts
3. Submit a screenshot of the table created as evidence of the customers table.
DROP TABLE CUSTOMERS;
CREATE TABLE CUSTOMERS
(
CST_NUM CHAR(4),
CST_NME_LST VARCHAR2(20),
CST_NME_FST VARCHAR2(20),
CST_EML VARCHAR2(25),
CST_ADR VARCHAR2(25),
CST_CTY VARCHAR2(20),
CST_ST CHAR(2),
CST_ZIP CHAR(5),
CST_REF NUMBER(4),
CST_REG CHAR(2)
);
2. Add Data to the Customers Table
1. Please add the following records to the customer table
2. Afterwards, submit a screenshot as evidence that the records have been populated to the table.
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1001′,’MORALES’,’BONITA’,’P.O.BOX 651′,’EASTPOINT’,’FL’,’32328′, NULL, ‘SE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1002’, ‘THOMPSON’, ‘RYAN’, ‘P.O. BOX 9835’, ‘SANTA MONICA’, ‘CA’, ‘90404’, NULL, ‘W’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1003’, ‘SMITH’, ‘LEILA’, ‘P.O. BOX 66’, ‘TALLAHASSEE’, ‘FL’, ‘32306’, NULL, ‘SE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1004’, ‘PIERSON’, ‘THOMAS’, ‘69821 SOUTH AVENUE’, ‘BOISE’, ‘ID’, ‘83707’, NULL, ‘NW’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1005’, ‘GIRARD’, ‘CINDY’, ‘P.O. BOX 851’, ‘SEATTLE’, ‘WA’, ‘98115’, NULL, ‘NW’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1006’, ‘CRUZ’, ‘MESHIA’, ’82 DIRT ROAD’, ‘ALBANY’, ‘NY’, ‘12211’, NULL, ‘NE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1007’, ‘GIANA’, ‘TAMMY’, ‘9153 MAIN STREET’, ‘AUSTIN’, ‘TX’, ‘78710’, ‘1003’, ‘SW’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1008’, ‘JONES’, ‘KENNETH’, ‘P.O. BOX 137’, ‘CHEYENNE’, ‘WY’, ‘82003’, NULL, ‘N’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1009’, ‘PEREZ’, ‘JORGE’, ‘P.O. BOX 8564’, ‘BURBANK’, ‘CA’, ‘91510’, ‘1003’, ‘W’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1010’, ‘LUCAS’, ‘JAKE’, ‘114 EAST SAVANNAH’, ‘ATLANTA’, ‘GA’, ‘30314’, NULL, ‘SE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1011’, ‘MCGOVERN’, ‘REESE’, ‘P.O. BOX 18’, ‘CHICAGO’, ‘IL’, ‘60606’, NULL, ‘N’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1012’, ‘MCKENZIE’, ‘WILLIAM’, ‘P.O. BOX 971’, ‘BOSTON’, ‘MA’, ‘02110’, NULL, ‘NE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1013’, ‘NGUYEN’, ‘NICHOLAS’, ‘357 WHITE EAGLE AVE.’, ‘CLERMONT’, ‘FL’, ‘34711’, ‘1006’, ‘SE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1014’, ‘LEE’, ‘JASMINE’, ‘P.O. BOX 2947’, ‘CODY’, ‘WY’, ‘82414’, NULL, ‘N’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1015’, ‘SCHELL’, ‘STEVE’, ‘P.O. BOX 677’, ‘MIAMI’, ‘FL’, ‘33111’, NULL, ‘SE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1016’, ‘DAUM’, ‘MICHELL’, ‘9851231 LONG ROAD’, ‘BURBANK’, ‘CA’, ‘91508’, ‘1010’, ‘W’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1017’, ‘NELSON’, ‘BECCA’, ‘P.O. BOX 563’, ‘KALMAZOO’, ‘MI’, ‘49006’, NULL, ‘N’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1018’, ‘MONTIASA’, ‘GREG’, ‘1008 GRAND AVENUE’, ‘MACON’, ‘GA’, ‘31206’, NULL, ‘SE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1019’, ‘SMITH’, ‘JENNIFER’, ‘P.O. BOX 1151’, ‘MORRISTOWN’, ‘NJ’, ‘07962’, ‘1003’, ‘NE’);
INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG)
VALUES (‘1020’, ‘FALAH’, ‘KENNETH’, ‘P.O. BOX 335’, ‘TRENTON’, ‘NJ’, ‘08607’, NULL, ‘NE’);
3. Display the following Queries
1. 1.All records from the customer table.
2. 2.List of all customers in the state of Florida
3. 3.All customers that reside in zip code 82003
4. 4.All customers with the last name Smith
5. 5. List all customers who live in Miami
