
use mytools;
DROP TABLE IF EXISTS customers2;

CREATE TABLE customers2 (cust_id INTEGER, first_name VARCHAR(20), last_name VARCHAR(20), home_address VARCHAR(20), city VARCHAR(20), state VARCHAR(20), zip_code VARCHAR(10));

INSERT INTO customers2 
VALUES (1000,'John','Smith','123 Main St','Fremont','CA','94123');

INSERT INTO customers2 
VALUES (2000,'Jane','Jones','456 Front St','Fremont','CA','95015');

INSERT INTO customers2 
VALUES (3000,'Sara','Smith','789 Other St','Fremont','CA','95043');

INSERT INTO customers2 
VALUES (4000,'Dave','Dean','789 Halsted St','Chicago','IL','67123');

INSERT INTO customers2 
VALUES (5000,'Kenn','Knuth','1234 Halsted St','Chicago','IL','67345');

