INSERT INTO Account VALUES (3,'Comet Psychiatrist', 'Evaluation and perscriptions', '1059 Synergy', 'Richardson', 'TX', 75252, '9727271543', 'www.cometpsych.com', 5);
INSERT INTO Account VALUES (4,'Pizza Johns', 'Pizza delivery', '819 W Arapaho Rd Ste 24a', 'Richardson', 'TX', 75252, '9727271655', 'www.pizzajohns.com', 9);
INSERT INTO Account VALUES (5,'Air Force 1', 'Aircraft sales', '4727 Frankford Rd Ste 341', 'Richardson', 'TX', 75252, '9727271999', 'www.af1.com', 10);
INSERT INTO Account VALUES (6,'Lava Lamps', 'Sells lights and lava lamps', '4733 Frankford Rd Ste 235', 'Richardson', 'TX', 75252, '9727271333', 'www.lavallamps.com', 6);
INSERT INTO Account VALUES (7,'Opal Sands', 'Resort', '430 S Gulfview Blvd', 'Clearwater Beach', 'FL', 33767, '2147271333', 'www.opalsands.com', 8);
INSERT INTO Account VALUES (8,'Michaels Marketing', 'Marketing services', '2435 N Central Expy 12th Floor Ste 2233A', 'Richardson', 'TX', 75080, '9727271333', 'www.michaelmarketing.com', 7);


INSERT INTO Contact VALUES (3,'Psychiatrist Overseer', 1,'Jane', 'Mo', '9727434566', 'janemo234@gmail.com', 3);
INSERT INTO Contact VALUES (4,'Pizza Man', 0,'Joe', 'Bigs', '9726432733', 'joepizza22@gmail.com', 4);
INSERT INTO Contact VALUES (5,'Piolot', 0,'Sal', 'Bucana', '2147338444', 'salbfive@gmail.com', 5);
INSERT INTO Contact VALUES (6,'Electrician', 0,'James', 'Borne', '9722233332', 'jamesfastelectric@hotmail.com', 6);
INSERT INTO Contact VALUES (7,'Resort Manager', 1,'Ellie', 'Roma', '9728765433', 'ellier1234@gmail.com', 7);
INSERT INTO Contact VALUES (8,'Marketing Manager', 1,'Susan', 'Anthony', '9723343332', 'sueanthony1@gmail.com', 8);


INSERT INTO Activity VALUES (3, 'phone', '2019-02-30', 'New Building', 'Psychiatrist Overseer would like to expand building', 3);
INSERT INTO Activity VALUES (4, 'email', '2019-01-30', 'New Store', 'Joe Bigs is looking to open a new pizza shop', 4);
INSERT INTO Activity VALUES (5, 'telegram', '2018-03-30', 'App Development', 'Air Force 1 would like to create an app', 5);
INSERT INTO Activity VALUES (6, 'skype', '2019-04-15', 'Advertizing', 'Electrician James Borne needs help advertizing lava lamps', 6);
INSERT INTO Activity VALUES (7, 'email', '2019-04-22', 'Resort Advertizing', 'Ms. Romma is looking to contract us for advertizing', 7);
INSERT INTO Activity VALUES (8, 'phone', '2019-05-23', 'Selling marketing tools', 'Susan Anthony wants to sell us marketing tools', 8);
INSERT INTO Activity VALUES (8, 'phone', '2019-05-24', 'Marketing tools rejected', 'We decided Susans marketing tools are of no need to us', 8);

INSERT INTO Opportunity VALUES (3,'Building Help',100300.00,'Proposal','2019-03-26',3,3);
INSERT INTO Opportunity VALUES (4,'Services for Opening',15000.00,'Proposal','2019-02-20',4,4);
INSERT INTO Opportunity VALUES (5,'App Development',20000.00,'In Progress','2019-01-26',5,5);
INSERT INTO Opportunity VALUES (6,'Advertizing',16000.00,'Approved','2019-05-26',6,6);
INSERT INTO Opportunity VALUES (7,'Resort Advertizing',60000.00,'Campaign in progress','2019-04-25',7,7);
INSERT INTO Opportunity VALUES (8,'Marketing Tools', 00.00,'Rejected','2019-05-24',8,8);