top of page

Database

Public·3 members
Codersarts

Use the OLTP logical schema below to build data warehouse tables in SQL

PART I: Use the OLTP logical schema below to build data warehouse tables in SQL:


Question 1: CEO of Entertainment Inc. wants to keep track of performance of engagement that each

customer and agent have engaged. For each customer and agent, he wants to know total contract

length by year, and contract success ratio (calculated by total number of contracts expired each year

divided by total amount of contract price each year). In addition, for each customer and agent he wants

to know total numbers of contracts expired each week, and total number of contracts still active each


251 Views
Codersarts

SQL Query assignment Help

Click Here to see questions


Solutions:


a)   select distinct(deck) as 'Deck',count(*) as ':total' from results group by deck;

b)   select c1,(t1.won+t2.won) 'won',(t1.loss+t2.loss) 'loses',   (t1.won+t2.won)+(t1.loss+t2.loss)  'total' from (select deckone c1,count(if(result=1,1,NULL)) as 'won',count(if(result=2,1,NULL)) as 'loss'  from matches where deckone!=decktwo group by deckone) t1,(select decktwo c2,count(if(result=2,1,NULL)) as 'won',count(if(result=1,1,NULL)) as 'loss'  from matches where deckone!=decktwo group by decktwo) t2 where t1.c1=t2.c2;

c)  SELECT t23.Deck,t23.x,(t12.win)/(t12.win+t12.loss) 'Global win',(t23.win)/(t23.win+t23.loss) 'Win vs X'  from       (select c1,(t1.won+t2.won) 'win',(t1.loss+t2.loss) 'loss', (t1.won+t2.won)+(t1.loss+t2.loss)  'total'       from       (select deckone c1,count(if(result=1,1,NULL)) as 'won',count(if(result=2,1,NULL)) as 'loss'  from matches where deckone!=decktwo group by deckone) t1,      (select decktwo c2,count(if(result=2,1,NULL)) as 'won',count(if(result=1,1,NULL)) as 'loss'  from matches where deckone!=decktwo group by decktwo) t2       where t1.c1=t2.c2 ) t12,      (select deckone Deck,decktwo 'x' ,count(if(result=1,1,NULL))/(count(if(result=1,1,NULL))+count(if(result=2,1,NULL))) 'global win' ,count(if(result=1,1,NULL)) as 'win',count(if(result=2,1,NULL)) as 'loss'             from matches where deckone!=decktwo group by deckone,decktwo       union      select decktwo Deck,deckone 'x',count(if(result=2,1,NULL))/(count(if(result=1,1,NULL))+count(if(result=2,1,NULL))) 'global win',count(if(result=2,1,NULL)) as 'win',count(if(result=1,1,NULL)) as 'loss'         from matches where deckone!=decktwo group by decktwo,deckone ) t23
where t12.c1=t23.Deck;

d)  SELECT ttt1.deck…

56 Views
JITENDRA KUMAR SINGH

Insert record into table using command prompt in oracle: Oracle Assignment Help

Command prompt should look like this:


*-----------------------------------------------*

* --New Customer Program-- *

*-----------------------------------------------*


Please enter the customer's SOCIAL SECURITY NUMBER: 837465538 (Input)

Please enter the customer's LAST NAME: koch


34 Views
JITENDRA KUMAR SINGH

SQL queries and some database optimizations: SQL Assignment Help

Hi,


i'm in need for some SQL queries.


And possibly some database optimizations.


Here is a small part of the database (tables and some insertions): https://www.db-fiddle.com/f/9knJYioBumiy932cBVBCMv/0


and a quick explanation of the tables:


results: identifies the results for a specific tid (tournament)


55 Views
JITENDRA KUMAR SINGH

Advanced SQL using Oracle: SQl Assignment Help

Load the createInsurance.txt script file to create and populate the tables necessary for this assignment. The insurance database includes the following tables: Employer, Member, Carrier, Plan and Agent.


Employers have employees (that are called members). The members subscribe (or elect) to participate in a health plan. These health plans are offered by Insurance Carriers and sold to Employers by Agents. The table relationships are defined for you and are pictured below. Review the table structures before you attempt to solve the assignment problems.



You will need to write the SQL to solve 14 query problems defined below. You will build a single script file named yourLastName_A8Script.txt that contains all your SQL and SQL/PL statement necessary to solve and format the 14 queries. Output must be directed to a single .txt file named yourLastName_A8Spool.txt. You will need to submit both files for grading.


Assignment Steps:


Step 1) Download and execute the…


169 Views
JITENDRA KUMAR SINGH
JITENDRA KUMAR SINGH
Jul 03, 2019

Solutions: Database creation ,tables , insert data


--drop table Member CASCADE CONSTRAINTS;
--drop table Employer CASCADE CONSTRAINTS;
--drop table Plan CASCADE CONSTRAINTS;
--drop table Carrier CASCADE CONSTRAINTS;
--drop table Agent CASCADE CONSTRAINTS;
--commit;
CREATE TABLE Carrier
( CarrierID varchar2(4) not null primary key,
  carName varchar2(35),
  carAddress varchar2(50),
  carCity varchar2(30),
  carStCode varchar2(2),
  carZip varchar2(10),
  carPhone varchar2(10),
  carWebSite varchar2(255),
  carContactFirstname varchar2(35),
  carContactLastName varchar2(35),
  carEmail varchar2(255)
);
commit;
INSERT INTO Carrier VALUES (
'ANTH','Anthem','100 East Way','Atlanta','GA','36366','9064773364','www.athem.org','Nate','Zechery','zechery.nate@anthem.org'
);
INSERT INTO Carrier VALUES (
'BCBS','Blue Cross Blue Shield','222 Sylvania Avenue','Toledo','OH','43613','4194743357','www.bcbs.com','Ann','Bailey','abailey@bcbs.com'
);
INSERT INTO Carrier VALUES (
'DLT','Delta Dental','439 South Parkway','Phoenix','AZ','65100','8864375036','www.deltadental.com','Madeline','Masters','mmasters@deltadental.com'
);
INSERT INTO Carrier VALUES (
'MM','Medical Mutual','6800 South Main','Pittsburgh','PA','12005','2074553300','www.medicalmutual.com','Emily','Hackson','ehackson@medicalmutual.com'
);
INSERT INTO Carrier VALUES (
'NWD','Nationwide','100 High Street','Columbus','OH','45020','6148550000','www.nationwide.com','Nick','Jacione','jacione.nick@nationwide.com'
);
INSERT INTO Carrier VALUES (
'PHC','Paramount Health Care Grp','PO Box 1228','Boston','MA','01445','2153781880','www.paramounthealth.org','Josh','Watkins','jwatkins@paramount.org'
);
commit;
CREATE TABLE Agent
( AgentID varchar2(5) not null primary key,
  agentFname varchar2(35),
  agentLName varchar2(35),
  agentPhone varchar2(13),
  AgentuperID varchar2(5),
  agentTitle varchar2(25)
);
Commit;
INSERT INTO Agent VALUES (
'AA020','Adam','Akerson','(440)123-1111','JR010','Salesman'
);
INSERT INTO Agent VALUES (
'BA550','Bill','Almes','(915)222-9999','JR010','Salesman'
);
INSERT INTO Agent VALUES (
'JR010','Jordan','Richards','(419)222-1212','JR990','District Manager'
);
INSERT INTO Agent VALUES (
'JR990','John','Robie','(419)841-1188', NULL,'VP Sales'
);
INSERT INTO Agent VALUES (
'LR020','Lauren','Renard','(419)290-1677', 'AA020','Intern'
);
INSERT INTO Agent VALUES (
'RB001','Ron','Bell','(419)841-1189',NULL,'President'
);
INSERT INTO Agent VALUES (
'TM220','Tom','Matthews','(704)377-2266','JR990','Regional Manager'
);
Commit;
CREATE TABLE Employer
( EmployerID integer not null primary key,
  emplName varchar2(35),
  emplAddress varchar2(50),
  emplCity varchar2(30),
  emplState varchar2(2),
  emplZip varchar2(10),
  emplPhone varchar2(10),
  emplContactFirstname varchar2(35),
  emplContactLastName varchar2(35),
  emplContactEmail varchar2(255),
  AgentID varchar2(5) references Agent
);
commit;
INSERT INTO Employer VALUES (
1,'Segal','#11 - Hwy 16','Bonneville','PA','54323','4092411234','Mark','Stark','mstark@segal.com', 'RB001'
);
INSERT INTO Employer VALUES (
2,'Fair Weather Enterprises','345 Wiltshire Ave','New Surrey','MA','76566','5372551200','John','Adams','jadams@hotmail.com', 'JR010'
);
INSERT INTO Employer VALUES (
3,'Halston and Co.','387 Roper Place','Midland','WY','12658','3049554300','Julie','Reynolds','jreynolds@halston.com', 'JR990'
);
INSERT INTO Employer VALUES (
4,'MMB Holdings','4090 Lethbridge','Creston','OH','44065','6141252115','Jack','James','jj33@yahoo.com', 'JR010'
);
INSERT INTO Employer VALUES (
5,'WardCo','35-9087 14 Street','Munro','MI','48114','7348438500','Paul','Tinnion','ptinnion@comcast.net', 'LR020'
);
INSERT INTO Employer VALUES (
6,'Bakertime Mobile','759 East 31 Ave','Trenton','AL','24568','6157435555','Martin','Jackson','jackson.martin@bakertime.com','JR990'
);
insert into Employer values (7, 'Skidoo', '12200 Toban Drive', 'Arlington', 'TX', '76011', '8175501252', 'Shirley', 'Kennedy', 'skennedy0@berkeley.edu', 'AA020');
insert into Employer values (8, 'Twitternation', '73 Nova Trail', 'Arlington', 'VA', '22234', '5712853529', 'Judith', 'Martinez', 'jmartinez1@domainmarket.com', 'JR010');
insert into Employer values (9, 'Babbleset', '904 Dottie Way', 'Shreveport', 'LA', '71137', '3188494834', 'Larry', 'Spencer', 'lspencer2@cdc.gov', 'TM220');
insert into Employer values (10, 'Kwimbee', '2 Ohio Trail', 'Fort Lauderdale', 'FL', '33305', '9542007888', 'Lillian', 'Snyder', 'lsnyder3@amazon.com', 'TM220');
insert into Employer values (11, 'Skalith', '4 Manitowish Lane', 'Indianapolis', 'IN', '46202', '7657670387', 'Jonathan', 'Graham', 'jgraham4@yellowbook.com', 'JR990');
commit;
CREATE TABLE Plan
( PlanID integer not null primary key,
  plnDescription varchar2(35),
  plnCost decimal (8,2),
  CarrierID varchar2(4) references Carrier
);
commit;
INSERT INTO Plan  VALUES (
1,'Single Basic Medical',125.00,'BCBS'
);
INSERT INTO Plan  VALUES (
2,'2-Party Basic Medical',240.00,'BCBS'
);
INSERT INTO Plan  VALUES (
3,'Family Basic Medical',285.00,'BCBS'
);
INSERT INTO Plan  VALUES (
4,'Single SuperMed',160.00,'ANTH'
);
INSERT INTO Plan  VALUES (
5,'2-Party SuperMed',275.00,'ANTH'
);
INSERT INTO Plan  VALUES (
6,'Family SuperMed',350.00,'ANTH'
);
INSERT INTO Plan  VALUES (
7,'Single Dental Only',85.00,'DLT'
);
INSERT INTO Plan  VALUES (
8,'Family Dental Only',190.00,'DLT'
);
INSERT INTO Plan  VALUES (
9,'Life Only',25.50,'NWD'
);
INSERT INTO Plan  VALUES (
10,'Single SuperMed with Dental',185.00,'MM'
);
INSERT INTO Plan  VALUES (
11,'2-Party SuperMed with Dental',320.00,'MM'
);
INSERT INTO Plan  VALUES (
12,'Family SuperMed with Dental',425.00,'MM'
);
commit;
CREATE TABLE Member
( MemberNo integer not null primary key,
  mbrFirstname varchar2(35),
  mbrLastName varchar2(35),
  mbrStreet varchar2(50),
  mbrCity varchar2(30),
  mbrState varchar2(2),
  mbrZip varchar2(10),
  mbrPhoneNo varchar2(10),
  PlanID integer references Plan,
  mbrEmail varchar2(255),
  mbrDateEffective date,
  employerID integer references Employer
);
commit;
INSERT INTO Member  VALUES (
1,'Val','Kelly','1489 Mockingbird Lane','Sherman','OK','75090','9038933947',3,'imafriend@hotmail.com',TO_DATE('30-SEP-2007', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
2,'George','Martin','875 Greenwaters','Lavender','OK','78947','4055272810',2,'georgem@kxyd.com',TO_DATE('30-JUN-2013', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
3,'Bob','Smith','222 West Oak','Silver','TX','76949','9047624451',3,'catchbob@home.com',TO_DATE('15-AUG-2001', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
4,'Baylee','Michaels','543 North Meridian','Crossett','AR','71635','8703643571',3,'onthego@hotmail.com',TO_DATE('16-SEP-2002', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
5,'Lisa','Kelly','37110 Huntington','Wichita','KS','67201','3168316887',2,'panda@excite.com',TO_DATE('18-MAY-2010', 'dd-MON-yyyy'),5
);
INSERT INTO Member  VALUES (
6,'Jacob','Richards','6114 Wandering Way','','OK','74501','9184266796',1,'laughsalot@friend.com',TO_DATE('02-FEB-2011', 'dd-MON-yyyy'),4
);
INSERT INTO Member  VALUES (
7,'Danette','Randolph','201 Everette Drive','Midland','TX','79701','9156997345',5,'lookatme@hotmail.com',TO_DATE('01-MAR-1997', 'dd-MON-yyyy'),4
);
INSERT INTO Member  VALUES (
8,'Elizabeth','Wells','2944 Rosehaven','Benton','AR','72022','5017943638',2,'lizzieisbusy@huntington.edu',TO_DATE('02-MAR-1991', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
9,'Joan','Viaze','4012 Ridgeway','Dodge City','KS','67843','6202252214',3,'jviaze@motorco.com',TO_DATE('04-MAY-2000', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
10,'Peter','Lansing','9459 Thorn Ridge','Muskogee','OK','74403','9186221380',3,'Planing@home.com',TO_DATE('05-JUL-2007', 'dd-MON-yyyy'),5
);
INSERT INTO Member  VALUES (
11,'Tan','Wu','2518 Van Buren','Midland','TX','79701','9156973993',3,'mrwutoyou@home.com',TO_DATE('06-OCT-2015', 'dd-MON-yyyy'),5
);
INSERT INTO Member  VALUES (
12,'Ken','Ho','1100 Red Ridge','Benton','AR','72022','5013151588',1,'howdyim@home.com',TO_DATE('08-SEP-2016', 'dd-MON-yyyy'),5
);
INSERT INTO Member  VALUES (
13,'Omar','Lavender','9494 Broken Gate','Dodge City','KS','67843','6202272889',1,'osharif@hotmail.com',TO_DATE('09-OCT-2014', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
14,'Gladys','Burgerman','2912 Crestline Drive','Miami','OK','74355','9185429652',9,'kx874474@hotmail.com',TO_DATE('04-SEP-1997', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
15,'Margaret','Shue','4949 Eagle Road','','TX','79701','9155200297',3,'iftheshuefits@merchants.org',TO_DATE('08-MAR-2003', 'dd-MON-yyyy'),6
);
INSERT INTO Member  VALUES (
16,'Debra','Sharman','1484 Cedar Lane','Benton','AR','72022','9157948546',3,'dshrmand@juniper.org',TO_DATE('12-SEP-2004', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
17,'Loubna','Parish','3132 Overland Park','Dodge City','KS','67843','6204081147',2,'lparish@hotmail.com',TO_DATE('16-SEP-2004', 'dd-MON-yyyy'),5
);
INSERT INTO Member  VALUES (
18,'Katie','Hsieh','784 Western Drive','Tulsa','OK','74110','9186642810',2,'khsieh1234@aol.com',TO_DATE('18-SEP-2006', 'dd-MON-yyyy'),6
);
INSERT INTO Member  VALUES (
19,'Paul','Kopochesky','1907 Greenburg Drive','Commerce','TX','75428','9038868630',1,'mrkopochesky@aol.com',TO_DATE('20-JAN-2008', 'dd-MON-yyyy'),4
);
INSERT INTO Member  VALUES (
20,'Frank','Bellmonte','7654 Collier','Clairemore','OK','74018','9183412943',1,'tangodancer@aol.com',TO_DATE('22-FEB-2009', 'dd-MON-yyyy'),6
);
INSERT INTO Member  VALUES (
21,'Fred','McMann','1988 South Hampton','','LA','71483','3186280652',1,'fredsred@hotmail.com',TO_DATE('24-JAN-2010', 'dd-MON-yyyy'),6
);
INSERT INTO Member  VALUES (
22,'Frank','Ackers','4204 Pebble Creek','Monroe','LA','71208','3186510957',2,'frankieaker@aol.coom',TO_DATE('26-MAR-2011', 'dd-MON-yyyy'),6
);
INSERT INTO Member  VALUES (
23,'Paul','Brady','5757 Crooked Creek','Bunkie','LA','71322','3183461071',2,'pbrady@aol.com',TO_DATE('28-APR-2012', 'dd-MON-yyyy'),4
);
INSERT INTO Member  VALUES (
24,'George','Levingston','9777 Old Willow','Bunkie','LA','71322','3188382382',4,'glevingston@auniv.edu',TO_DATE('30-APR-2012', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
25,'Tabitha','Daniels','100 North Gaylord Drive','Oklahoma City','OK','73109','4057511755',2,'tdaniels@marshalls.com',TO_DATE('08-MAR-2001', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
26,'Vonka','Viera','9432 Mercer Lane','Sherman','TX','75090','9038943147',7,'vviera9484@aol.com',TO_DATE('03-FEB-1999', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
27,'Lola','Dougherty','5874 Nightingale Lane','Sherman','TX','75090','9038932913',4,'lrrrablelola@home.com',TO_DATE('12-SEP-2013', 'dd-MON-yyyy'),1
);
INSERT INTO Member  VALUES (
28,'Mark','Wallace','Apt. 23, Avondale Drive','Dallas','TX','75208','9729139572',1,'callwally@hotmail.com',TO_DATE('12-APR-2015', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
29,'Tracy','James','3847 Rocky Road','Little Rock','AR','72211','5012194804',2,'inthought@morganhills.com',TO_DATE('11-SEP-2016', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
30,'Peter','Gallant','4839 Broadway','Tulsa','OK','74109','9186641333',2,'marathonrunner@fastnetwork.com',TO_DATE('22-JUL-2012', 'dd-MON-yyyy'),2
);
INSERT INTO Member  VALUES (
31,'Joan','Allen','56 Wellsley Road','Commerce','OK','75429','9186750722',4,'fastcatcher@aol.com',TO_DATE('01-MAY-1988', 'dd-MON-yyyy'),6
);
INSERT INTO Member  VALUES (
32,'Loubna','Parish','3132 Overland Park','Dodge City','KS','67843','6204081147',2,'lparich@hotmail.com',TO_DATE('14-JAN-2010', 'dd-MON-yyyy'),4
);
insert into Member      VALUES (33, 'Alan', 'Olson', '5145 Scofield Drive', 'Kansas City', 'MO', '64130', '8166970261', 1, 'aolson0@soundcloud.com', '17-Aug-2015', 1);
insert into Member      VALUES (34, 'Elizabeth', 'Elliott', '66130 Hanson Trail', 'Buffalo', 'NY', '14205', '7165726524', 2, 'eelliott1@artisteer.com', '10-Sep-2016', 2);
insert into Member      VALUES (43, 'Jean', 'Lawrence', '2157 Portage Junction', 'Lansing', 'MI', '48901', '5175790115', 4, 'jlawrence2@github.com', '12-Jan-2016', 3);
insert into Member      VALUES (44, 'Samuel', 'Rose', '524 Eastwood Court', 'Winston Salem', 'NC', '27105', '3363371097', 5, 'srose3@furl.net', '07-Apr-2016', 1);
insert into Member      VALUES (45, 'Andrew', 'Owens', '29 Talmadge Drive', 'Independence', 'MO', '64054', '8162577649', 6, 'aowens4@bizjournals.com', '27-Mar-2017', 2);
insert into Member      VALUES (46, 'Daniel', 'Cox', '7070 Arrowood Alley', 'Hartford', 'CT', '06140', '8607711351', 12, 'dcox5@cdbaby.com', '28-Jun-2010', 2);
insert into Member      VALUES (47, 'Cheryl', 'Howell', '0 Banding Center', 'Albany', 'NY', '12227', '5184278088', 10, 'chowell6@hc360.com', '12-Sep-2016', 3);
insert into Member      VALUES (48, 'Bruce', 'Morales', '3 Cody Pass', 'Biloxi', 'MS', '39534', '2287010816', 12, 'bmorales7@timesonline.co.uk', '18-Jun-2010', 6);
insert into Member      VALUES (49, 'James', 'Franklin', '7565 Fieldstone Court', 'Topeka', 'KS', '66606', '7859802737', 5, 'jfranklin8@edublogs.org', '20-Nov-2016', 6);
insert into Member      VALUES (50, 'Louise', 'Wells', '6121 Mayfield Trail', 'Miami', 'FL', '33261', '3054177946', 6, 'lwells9@zimbio.com', '01-Oct-2010', 6);
insert into Member      VALUES (51, 'Timothy', 'Russell', '2 Kennedy Plaza', 'Tacoma', 'WA', '98405', '2531473762', 7, 'trussella@dyndns.org', '11-Jan-2016', 8);
insert into Member      VALUES (52, 'Rachel', 'Hart', '43 Brentwood Avenue', 'Columbia', 'SC', '29240', '8036217909', 6, 'rhartb@blinklist.com', '07-Apr-2016', 8);
insert into Member      VALUES (53, 'Tina', 'Hansen', '54574 Hooker Hill', 'Charleston', 'WV', '25331', '3042733024', 7, 'thansenc@imageshack.us', '14-Jun-2014', 8);
insert into Member      VALUES (54, 'Juan', 'Payne', '3887 Morningstar Lane', 'Houston', 'TX', '77050', '2812675251', 6, 'jpayned@cpanel.net', '11-Oct-2010', 7);
insert into Member      VALUES (55, 'Keith', 'Kennedy', '5026 David Trail', 'Hattiesburg', 'MS', '39404', '6012159841', 3, 'kkennedye@ox.ac.uk', '20-Apr-2016', 9);
insert into Member      VALUES (56, 'Marie', 'Carr', '04461 Glacier Hill Parkway', 'New York City', 'NY', '10004', '7183084272', 6, 'mcarrf@buzzfeed.com', '06-Jan-2012', 9);
insert into Member      VALUES (57, 'Victor', 'Medina', '2 Lake View Place', 'Fort Myers', 'FL', '33913', '2394850766', 6, 'vmedinag@imageshack.us', '11-Feb-2016', 9);
insert into Member      VALUES (58, 'Randy', 'Martinez', '190 Arkansas Way', 'Indianapolis', 'IN', '46226', '3178836450', 2, 'rmartinezh@salon.com', '23-Jun-2016', 5);
insert into Member      VALUES (59, 'Larry', 'Rogers', '674 Dayton Lane', 'Terre Haute', 'IN', '47805', '8129961728', 3, 'lrogersi@europa.eu', '14-Nov-2013', 1);
insert into Member      VALUES (60, 'Terry', 'Carter', '2 Surrey Place', 'Berkeley', 'CA', '94705', '5102125262', 4, 'tcarterj@apache.org', '16-Nov-2015', 2);
insert into Member      VALUES (61, 'Janet', 'Willis', '8887 Pearson Junction', 'Portland', 'OR', '97255', '9715710647', 5, 'jwillisk@yahoo.com', '21-Oct-2013', 3);
insert into Member      VALUES (62, 'Debra', 'Gibson', '4133 Sachtjen Park', 'Macon', 'GA', '31205', '4788746612', 7, 'dgibsonl@go.com', '04-Sep-2015', 11);
insert into Member      VALUES (63, 'Paula', 'Ortiz', '85 Independence Parkway', 'Baltimore', 'MD', '21290', '4109284723', 7, 'portizm@eepurl.com', '28-Jun-2014', 11);
insert into Member      VALUES (64, 'Jessica', 'Baker', '17 Manley Point', 'Tampa', 'FL', '33680', '8136981662', 9, 'jbakern@blinklist.com', '13-Feb-2012', 10);
insert into Member      VALUES (65, 'John', 'Robinson', '547 Graedel Junction', 'Minneapolis', 'MN', '55407', '6512424596', 10, 'jrobinsono@smh.com.au', '16-Oct-2016', 9);
insert into Member      VALUES (66, 'Judith', 'Rice', '94869 Barnett Center', 'Dallas', 'TX', '75392', '2145394920', 10, 'jricep@e-recht24.de', '21-Jun-2011', null);
insert into Member      VALUES (67, 'Russell', 'Richards', '3 Mockingbird Crossing', 'Tampa', 'FL', '33620', '8135707634', 10, 'rrichardsq@netlog.com', '29-Jul-2014', 2);
insert into Member      VALUES (68, 'David', 'Harvey', '2 Lotheville Avenue', 'Midland', 'TX', '79705', '4327838380', 1, 'dharveyr@elpais.com', '23-Apr-2015', 6);
insert into Member      VALUES (69, 'Ernest', 'Stewart', '5481 Anniversary Lane', 'Lima', 'OH', '45807', '4199601768', 1, 'estewarts@hibu.com', '03-May-2016', 6);
insert into Member      VALUES (70, 'Howard', 'Pierce', '9 Dovetail Point', 'San Diego', 'CA', '92186', '6198261963', 1, 'hpiercet@mail.ru', '14-Jan-2017', 8);
insert into Member      VALUES (71, 'Nicole', 'Banks', '77 Algoma Junction', 'Houston', 'TX', '77206', '7137592453', 3, 'nbanksu@youku.com', '03-Apr-2016', 9);
insert into Member      VALUES (72, 'Arthur', 'Adams', '18 2nd Court', 'New York City', 'NY', '10014', '3475056191', 4, 'aadamsv@apple.com', '04-Jul-2013', 3);
insert into Member      VALUES (73, 'Kathryn', 'Perry', '2 Manitowish Plaza', 'Detroit', 'MI', '48211', '7344243517', 4, 'kperryw@elpais.com', '30-Aug-2015', 3);
insert into Member      VALUES (74, 'Christine', 'Reynolds', '547 Mandrake Drive', 'Abilene', 'TX', '79605', '3256468565', 5, 'creynoldsx@addthis.com', '23-Nov-2016', 4);
insert into Member      VALUES (75, 'Christina', 'Bell', '4 Talmadge Terrace', 'Orlando', 'FL', '32891', '4075151798', 6, 'cbelly@newsvine.com', '23-Sep-2015', 4);
insert into Member      VALUES (76, 'Denise', 'Perkins', '0 Onsgard Avenue', 'Wichita Falls', 'TX', '76305', '9406630869', 6, 'dperkinsz@usnews.com', '23-Dec-2014', 5);
insert into Member      VALUES (77, 'Judy', 'Schmidt', '886 Hovde Pass', 'Anniston', 'AL', '36205', '2568885760', 10, 'jschmidt10@huffingtonpost.com', '30-Jun-2012', 5);
insert into Member      VALUES (78, 'Sara', 'Dixon', '70696 Novick Place', 'Canton', 'OH', '44720', '2342879824', 2, 'sdixon11@ameblo.jp', '18-Nov-2014', 5);
insert into Member      VALUES (79, 'William', 'Brooks', '55 New Castle Plaza', 'Abilene', 'TX', '79605', '3254476634', 2, 'wbrooks12@alibaba.com', '20-May-2015', 6);
insert into Member      VALUES (80, 'Lois', 'West', '4 Vernon Terrace', 'Orlando', 'FL', '32819', '3218924409', 4, 'lwest13@indiegogo.com', '04-Apr-2011', 1);
commit;
update Member
set planid = null
where memberno in (7, 21, 27, 50, 60, 70);
commit;

    Members

    See All Members (3)
    bottom of page