I need someone to query my Oracle database
//////////////////////////////////////////////CLUB INSERT STATEMENTS///////////////////////////////////////////////////////////////////// INSERT INTO club VALUES ('CAMAC01', 'CAMBRIDGE ATHLETIC CLUB', '22 ARBURY ROAD', '01223639801', '40.50'); INSERT INTO club VALUES ('NORAC01', 'NORWICH ATHLETIC CLUB', '124 MILL LANE', '01603235190', '59.99'); INSERT INTO club VALUES ('IPSAC01', 'IPSWICH ATHLETIC CLUB', '16 PARK ROAD', '01473119478', '35.00'); INSERT INTO club VALUES ('COLAC01', 'COLCHESTER ATHLETIC CLUB', '76 ROTARY WAY', '01206547731', '110.8'); INSERT INTO club VALUES ('PETAC01', 'PETERBOROUGH ATHLETIC CLUB', '92 WELLINGTON STREET', '01733343268', '90.2'); ////////////////////////////////////////////////MEMBER INSERT STATEMENTS////////////////////////////////////////////////////////////////// INSERT INTO member VALUES ('CAMACMEM001', 'FRED', 'MASON', '1 HAUK TERRACE', '01204746193'); INSERT INTO member VALUES ('CAMACMEM002', 'HELEN', 'FLORES', '814 PARKSIDE CROSSING', '01204435112'); INSERT INTO member VALUES ('CAMACMEM003', 'BRENDA', 'LEE', '37 SYCAMORE PLACE', '01204223096'); INSERT INTO member VALUES ('CAMACMEM004', 'PAULA', 'DIAZ', '670 SAGE PASS', '01204994552'); INSERT INTO member VALUES ('CAMACMEM005', 'DAVID', 'SMITH', '193 TONY DRIVE', '01204284654'); INSERT INTO member VALUES ('CAMACMEM006', 'EMILY', 'RIVIERA', '441 LAKEWOOD GARDENS', '01204466325'); INSERT INTO member VALUES ('CAMACMEM007', 'LEWIS', 'CARPENTER', '848 MERCHANT AVENUE', '01204067345'); INSERT INTO member VALUES ('CAMACMEM008', 'DONALD', 'WAGNER', '567 STEPHEN ROAD', '01204118734'); INSERT INTO member VALUES ('CAMACMEM009', 'SARAH', 'HUGHES', '317 JACKSON WAY', '01204401232'); INSERT INTO member VALUES ('CAMACMEM010', 'JAMES', 'WOOD', '15 GERALD STREET', '01204674103'); INSERT INTO member VALUES ('NORACMEM001', 'DENNIS', 'SIMMONS', '50 CLAREMONT COURT', '01207993674'); INSERT INTO member VALUES ('NORACMEM002', 'BENJAMIN', 'DANIELS', '306 CARBERRY DRIVE', '01207012499'); INSERT INTO member VALUES ('NORACMEM003', 'RUTH', 'CAMPBELL', '124 REIDER PARK WAY', '01207388215'); INSERT INTO member VALUES ('NORACMEM004', 'ANDREW', 'HUGHES', '63 BIRCHWOOD WAY', '01207463419'); INSERT INTO member VALUES ('NORACMEM005', 'DONALD', 'NELSON', '11 DORTON DRIVE', '01207344312'); INSERT INTO member VALUES ('NORACMEM006', 'PAMELA', 'FRAZIER', '87 NORTHRIDGE TRAIL', '01207220986'); INSERT INTO member VALUES ('NORACMEM007', 'CRAIG', 'PEREZ', '111 DIXON PLAZA', '01207589872'); INSERT INTO member VALUES ('NORACMEM008', 'DENNIS', 'THOMPSON', '73 ALGOMA LANE', '01207393776'); INSERT INTO member VALUES ('NORACMEM009', 'PATRICIA', 'MARTIN', '65 PARKSIDE LANE', '01207112998'); INSERT INTO member VALUES ('NORACMEM010', 'JOSEPH', 'MATTHEWS', '1 TOWNE HILL', '01207229773'); INSERT INTO member VALUES ('IPSACMEM001', 'ANTHONY', 'WOOD', '44 SUMMERVIEW CIRCLE', '01210459817'); INSERT INTO member VALUES ('IPSACMEM002', 'LAWRENCE', 'RUSSELL', '54 STANG ALLEY', '01210109305'); INSERT INTO member VALUES ('IPSACMEM003', 'AARON', 'BANKS', '244 LOEPRICH PLACE', '01210449089'); INSERT INTO member VALUES ('IPSACMEM004', 'FRED', 'REYNOLDS', '5 MAGDELINE AVENUE', '01210226521'); INSERT INTO member VALUES ('IPSACMEM005', 'DENISE', 'JOHNSON', '156 DAYTON CIRCLE', '01210776690'); INSERT INTO member VALUES ('IPSACMEM006', 'LAURA', 'STEPHENS', '546 MESSERSCHMIDT LANE', '01210239034'); INSERT INTO member VALUES ('IPSACMEM007', 'KATHY', 'STEPHENS', '546 MESSERSCHMIDT LANE', '01210239034'); INSERT INTO member VALUES ('IPSACMEM008', 'LAWRENCE', 'STEWART', '39 RIVERSIDE WAY', '01210556447'); INSERT INTO member VALUES ('IPSACMEM009', 'PATRICIA', 'PRICE', '87 RIVERSIDE WAY', '01210014876'); INSERT INTO member VALUES ('IPSACMEM010', 'KENNETH', 'THOMPSON', '285 STANG ALLEY', '01210433167'); INSERT INTO member VALUES ('COLACMEM001', 'CAROL', 'MURPHY', '68 KINGS TERRACE', '01210213067'); INSERT INTO member VALUES ('COLACMEM002', 'SANDRA', 'BANKS', '665 EXPRESS PLAZA', '01210856467'); INSERT INTO member VALUES ('COLACMEM003', 'RYAN', 'BUTLER', '363 BLUESTEM CIRCLE', '01210778123'); INSERT INTO member VALUES ('COLACMEM004', 'PAULA', 'FIELDS', '52 MOSINEE TERRACE', '01210430921'); INSERT INTO member VALUES ('COLACMEM005', 'JOSEPH', 'WEST', '62 DAWN DRIVE', '01210338339'); INSERT INTO member VALUES ('COLACMEM006', 'DANIEL', 'WEST', '62 DAWN DRIVE', '01210338339'); INSERT INTO member VALUES ('COLACMEM007', 'MICHELLE', 'WEST', '62 DAWN DRIVE', '01210338339'); INSERT INTO member VALUES ('COLACMEM008', 'JEAN', 'DUNCAN', '2 TONY CENTER', '01210897863'); INSERT INTO member VALUES ('COLACMEM009', 'TERRY', 'CONROY', '59 NEW CASTLE TERRACE', '01210388856'); INSERT INTO member VALUES ('COLACMEM010', 'PHILLIP', 'BLACK', '22 FOREST WALK', '01210288423'); INSERT INTO member VALUES ('PETACMEM001', 'JANE', 'WELLS', '1995 ESCH PARK', '01270219045'); INSERT INTO member VALUES ('PETACMEM002', 'PATRICK', 'SCHMIDT', '404 HOFFMAN WAY', '01270110983'); INSERT INTO member VALUES ('PETACMEM003', 'LISA', 'HARPER', '715 GRANBY PLACE', '01270556232'); INSERT INTO member VALUES ('PETACMEM004', 'DONNA', 'HICKS', '19 MELBY TRAIL', '01270132945'); INSERT INTO member VALUES ('PETACMEM005', 'JAMES', 'HICKS', '19 MELBY TRAIL', '01270132945'); INSERT INTO member VALUES ('PETACMEM006', 'KELLY', 'ROGERS', '28 MELBY TRAIL', '01270132341'); INSERT INTO member VALUES ('PETACMEM007', 'MARIA', 'WATKINS', '56 HARPER PARK', '01270165432'); INSERT INTO member VALUES ('PETACMEM008', 'BARBARA', 'HAWKINS', '79 SWALLOW STREET', '01270454989'); INSERT INTO member VALUES ('PETACMEM009', 'LAURA', 'SMITH', '23 LONGDOWN LANE', '01270232365'); INSERT INTO member VALUES ('PETACMEM010', 'RICHARD', 'SMITH', '23 LONGDOWN LANE', '01270232365'); //////////////////////////////////SUBSCRIPTION INSERT STATEMENTS///////////////////////////////////////////////////////////////////////// INSERT INTO subscription VALUES ('CAMACMEM001', 'CAMAC01', '21-JUL-2012'); INSERT INTO subscription VALUES ('CAMACMEM002', 'CAMAC01', '11-MAR-2014'); INSERT INTO subscription VALUES ('CAMACMEM003', 'CAMAC01', '14-MAY-2011'); INSERT INTO subscription VALUES ('CAMACMEM004', 'CAMAC01', '01-JUN-2015'); INSERT INTO subscription VALUES ('CAMACMEM005', 'CAMAC01', '19-JUN-2012'); INSERT INTO subscription VALUES ('CAMACMEM006', 'CAMAC01', '09-DEC-2012'); INSERT INTO subscription VALUES ('CAMACMEM007', 'CAMAC01', '07-FEB-2013'); INSERT INTO subscription VALUES ('CAMACMEM008', 'CAMAC01', '29-OCT-2010'); INSERT INTO subscription VALUES ('CAMACMEM009', 'CAMAC01', '15-OCT-2011'); INSERT INTO subscription VALUES ('CAMACMEM010', 'CAMAC01', '03-AUG-2007'); INSERT INTO subscription VALUES ('NORACMEM001', 'NORAC01', '09-NOV-2009'); INSERT INTO subscription VALUES ('NORACMEM002', 'NORAC01', '05-NOV-2009'); INSERT INTO subscription VALUES ('NORACMEM003', 'NORAC01', '18-JAN-2010'); INSERT INTO subscription VALUES ('NORACMEM004', 'NORAC01', '21-NOV-2010'); INSERT INTO subscription VALUES ('NORACMEM005', 'NORAC01', '12-AUG-2014'); INSERT INTO subscription VALUES ('NORACMEM006', 'NORAC01', '17-AUG-2013'); INSERT INTO subscription VALUES ('NORACMEM007', 'NORAC01', '19-APR-2012'); INSERT INTO subscription VALUES ('NORACMEM008', 'NORAC01', '24-APR-2015'); INSERT INTO subscription VALUES ('NORACMEM009', 'NORAC01', '20-JUL-2015'); INSERT INTO subscription VALUES ('NORACMEM010', 'NORAC01', '09-MAY-2016'); INSERT INTO subscription VALUES ('IPSACMEM001', 'IPSAC01', '17-MAY-2014'); INSERT INTO subscription VALUES ('IPSACMEM002', 'IPSAC01', '23-JUL-2010'); INSERT INTO subscription VALUES ('IPSACMEM003', 'IPSAC01', '14-MAR-2012'); INSERT INTO subscription VALUES ('IPSACMEM004', 'IPSAC01', '18-AUG-2015'); INSERT INTO subscription VALUES ('IPSACMEM005', 'IPSAC01', '09-DEC-2011'); INSERT INTO subscription VALUES ('IPSACMEM006', 'IPSAC01', '04-SEP-2015'); INSERT INTO subscription VALUES ('IPSACMEM007', 'IPSAC01', '24-JAN-2015'); INSERT INTO subscription VALUES ('IPSACMEM008', 'IPSAC01', '19-FEB-2010'); INSERT INTO subscription VALUES ('IPSACMEM009', 'IPSAC01', '06-JUN-2013'); INSERT INTO subscription VALUES ('IPSACMEM010', 'IPSAC01', '11-MAR-2015'); INSERT INTO subscription VALUES ('COLACMEM001', 'COLAC01', '15-MAR-2016'); INSERT INTO subscription VALUES ('COLACMEM002', 'COLAC01', '22-DEC-2014'); INSERT INTO subscription VALUES ('COLACMEM003', 'COLAC01', '28-OCT-2012'); INSERT INTO subscription VALUES ('COLACMEM004', 'COLAC01', '23-JAN-2009'); INSERT INTO subscription VALUES ('COLACMEM005', 'COLAC01', '20-JUL-2013'); INSERT INTO subscription VALUES ('COLACMEM006', 'COLAC01', '11-SEP-2014'); INSERT INTO subscription VALUES ('COLACMEM007', 'COLAC01', '15-MAY-2014'); INSERT INTO subscription VALUES ('COLACMEM008', 'COLAC01', '19-AUG-2015'); INSERT INTO subscription VALUES ('COLACMEM009', 'COLAC01', '29-AUG-2016'); INSERT INTO subscription VALUES ('COLACMEM010', 'COLAC01', '30-NOV-2015'); INSERT INTO subscription VALUES ('PETACMEM001', 'PETAC01', '02-OCT-2013'); INSERT INTO subscription VALUES ('PETACMEM002', 'PETAC01', '11-FEB-2013'); INSERT INTO subscription VALUES ('PETACMEM003', 'PETAC01', '17-FEB-2012'); INSERT INTO subscription VALUES ('PETACMEM004', 'PETAC01', '19-MAY-2012'); INSERT INTO subscription VALUES ('PETACMEM005', 'PETAC01', '25-SEP-2010'); INSERT INTO subscription VALUES ('PETACMEM006', 'PETAC01', '21-JAN-2011'); INSERT INTO subscription VALUES ('PETACMEM007', 'PETAC01', '10-MAR-2011'); INSERT INTO subscription VALUES ('PETACMEM008', 'PETAC01', '29-MAR-2016'); INSERT INTO subscription VALUES ('PETACMEM009', 'PETAC01', '31-MAR-2016'); INSERT INTO subscription VALUES ('PETACMEM010', 'PETAC01', '05-JUL-2010'); /////////////////////////////////////////////////////////MEETING INSERT STATEMENTS/////////////////////////////////// INSERT INTO meeting VALUES ('MEET0001', 'CAMBRIDGE AC SPORTS DAY', '15-JUL-2016', 'CAMAC01'); INSERT INTO meeting VALUES ('MEET0002', 'CAMBRIDGE AC ATHLETIC COMPETITION', '29-MAR-2016', 'CAMAC01'); INSERT INTO meeting VALUES ('MEET0003', 'NORWICH AC SPORTS DAY', '01-FEB-2015', 'NORAC01'); INSERT INTO meeting VALUES ('MEET0004', 'NORWICH AC ATHLETIC COMPETITION', '25-MAY-2014', 'NORAC01'); INSERT INTO meeting VALUES ('MEET0005', 'IPSWICH AC SPORTS EVENT', '22-AUG-2014', 'IPSAC01'); INSERT INTO meeting VALUES ('MEET0006', 'COLCHESTER AC SPORTS COMPETITION', '16-JUN-2013', 'COLAC01'); INSERT INTO meeting VALUES ('MEET0007', 'PETERBOROUGH AC SPORTS DAY', '18-JUL-2015', 'PETAC01'); INSERT INTO meeting VALUES ('MEET0008', 'PETERBOROUGH AC ATHLETIC COMPETITION', '18-JUL-2015', 'PETAC01'); //////////////////////////////////////////////////////////ATTENDANCE INSERT STATEMENTS//////////////////////////////////// INSERT INTO attendance VALUES ('CAMACMEM001', 'MEET0002'); INSERT INTO attendance VALUES ('CAMACMEM004', 'MEET0001'); INSERT INTO attendance VALUES ('CAMACMEM004', 'MEET0002'); INSERT INTO attendance VALUES ('CAMACMEM005', 'MEET0002'); INSERT INTO attendance VALUES ('CAMACMEM006', 'MEET0001'); INSERT INTO attendance VALUES ('CAMACMEM006', 'MEET0002'); INSERT INTO attendance VALUES ('CAMACMEM007', 'MEET0002'); INSERT INTO attendance VALUES ('CAMACMEM010', 'MEET0001'); INSERT INTO attendance VALUES ('NORACMEM002', 'MEET0004'); INSERT INTO attendance VALUES ('NORACMEM003', 'MEET0004'); INSERT INTO attendance VALUES ('NORACMEM005', 'MEET0003'); INSERT INTO attendance VALUES ('NORACMEM005', 'MEET0004'); INSERT INTO attendance VALUES ('NORACMEM007', 'MEET0003'); INSERT INTO attendance VALUES ('NORACMEM008', 'MEET0003'); INSERT INTO attendance VALUES ('NORACMEM010', 'MEET0003'); INSERT INTO attendance VALUES ('NORACMEM010', 'MEET0004'); INSERT INTO attendance VALUES ('IPSACMEM003', 'MEET0005'); INSERT INTO attendance VALUES ('IPSACMEM004', 'MEET0005'); INSERT INTO attendance VALUES ('IPSACMEM006', 'MEET0005'); INSERT INTO attendance VALUES ('IPSACMEM007', 'MEET0005'); INSERT INTO attendance VALUES ('IPSACMEM009', 'MEET0005'); INSERT INTO attendance VALUES ('IPSACMEM010', 'MEET0005'); INSERT INTO attendance VALUES ('COLACMEM002', 'MEET0006'); INSERT INTO attendance VALUES ('COLACMEM003', 'MEET0006'); INSERT INTO attendance VALUES ('COLACMEM005', 'MEET0006'); INSERT INTO attendance VALUES ('COLACMEM006', 'MEET0006'); INSERT INTO attendance VALUES ('COLACMEM008', 'MEET0006'); INSERT INTO attendance VALUES ('PETACMEM002', 'MEET0007'); INSERT INTO attendance VALUES ('PETACMEM002', 'MEET0008'); INSERT INTO attendance VALUES ('PETACMEM004', 'MEET0008'); INSERT INTO attendance VALUES ('PETACMEM005', 'MEET0008'); INSERT INTO attendance VALUES ('PETACMEM006', 'MEET0007'); INSERT INTO attendance VALUES ('PETACMEM007', 'MEET0007'); INSERT INTO attendance VALUES ('PETACMEM007', 'MEET0008'); INSERT INTO attendance VALUES ('PETACMEM010', 'MEET0008'); /////////////////////////////////////////////////////EVENT INSERT STATEMENTS/////////////////////////////////////////////////////// INSERT INTO event VALUES ('EVENT001', 'TRACK', '100M'); INSERT INTO event VALUES ('EVENT002', 'TRACK', '200M'); INSERT INTO event VALUES ('EVENT003', 'TRACK', 'RELAY'); INSERT INTO event VALUES ('EVENT004', 'FIELD', 'JAVELIN'); INSERT INTO event VALUES ('EVENT005', 'FIELD', 'HIGH JUMP'); INSERT INTO event VALUES ('EVENT006', 'SWIMMING', '50M'); INSERT INTO event VALUES ('EVENT007', 'SWIMMING', '100M'); ////////////////////////////////////////////////RANK INSERT STATEMENTS////////////////////////////////////////////////// INSERT INTO rank VALUES ('CAMACMEM001', 'MEET0002', 'EVENT006', '16.7'); INSERT INTO rank VALUES ('CAMACMEM004', 'MEET0001', 'EVENT001', '14.3'); INSERT INTO rank VALUES ('CAMACMEM004', 'MEET0002', 'EVENT002', '20.3'); INSERT INTO rank VALUES ('CAMACMEM005', 'MEET0002', 'EVENT001', '13.8'); INSERT INTO rank VALUES ('CAMACMEM006', 'MEET0001', 'EVENT001', '15.1'); INSERT INTO rank VALUES ('CAMACMEM006', 'MEET0002', 'EVENT005', '12.7'); INSERT INTO rank VALUES ('CAMACMEM007', 'MEET0001', 'EVENT003', '25.5'); INSERT INTO rank VALUES ('CAMACMEM010', 'MEET0002', 'EVENT004', '11.9'); INSERT INTO rank VALUES ('COLACMEM002', 'MEET0006', 'EVENT004', '14.3'); INSERT INTO rank VALUES ('COLACMEM003', 'MEET0006', 'EVENT001', '15.7'); INSERT INTO rank VALUES ('COLACMEM005', 'MEET0006', 'EVENT006', '15.2'); INSERT INTO rank VALUES ('COLACMEM006', 'MEET0006', 'EVENT003', '23.2'); INSERT INTO rank VALUES ('COLACMEM008', 'MEET0006', 'EVENT005', '19.8'); INSERT INTO rank VALUES ('IPSACMEM003', 'MEET0005', 'EVENT002', '16.0'); INSERT INTO rank VALUES ('IPSACMEM004', 'MEET0005', 'EVENT005', '12.6'); INSERT INTO rank VALUES ('IPSACMEM006', 'MEET0005', 'EVENT001', '12.5'); INSERT INTO rank VALUES ('IPSACMEM007', 'MEET0005', 'EVENT002', '18.4'); INSERT INTO rank VALUES ('IPSACMEM009', 'MEET0005', 'EVENT004', '26.4'); INSERT INTO rank VALUES ('IPSACMEM010', 'MEET0005', 'EVENT006', '17.4'); INSERT INTO rank VALUES ('NORACMEM002', 'MEET0004', 'EVENT004', '20.4'); INSERT INTO rank VALUES ('NORACMEM003', 'MEET0003', 'EVENT003', '13.2'); INSERT INTO rank VALUES ('NORACMEM005', 'MEET0003', 'EVENT001', '15.1'); INSERT INTO rank VALUES ('NORACMEM005', 'MEET0004', 'EVENT006', '18.7'); INSERT INTO rank VALUES ('NORACMEM007', 'MEET0003', 'EVENT005', '12.7'); INSERT INTO rank VALUES ('NORACMEM008', 'MEET0003', 'EVENT003', '11.2'); INSERT INTO rank VALUES ('NORACMEM010', 'MEET0003', 'EVENT003', '10.1'); INSERT INTO rank VALUES ('NORACMEM010', 'MEET0004', 'EVENT005', '17.5'); INSERT INTO rank VALUES ('PETACMEM002', 'MEET0007', 'EVENT005', '13.6'); INSERT INTO rank VALUES ('PETACMEM002', 'MEET0008', 'EVENT007', '18.4'); INSERT INTO rank VALUES ('PETACMEM004', 'MEET0008', 'EVENT002', '14.4'); INSERT INTO rank VALUES ('PETACMEM005', 'MEET0008', 'EVENT007', '13.6'); INSERT INTO rank VALUES ('PETACMEM006', 'MEET0007', 'EVENT002', '19.1'); INSERT INTO rank VALUES ('PETACMEM007', 'MEET0007', 'EVENT001', '14.1'); INSERT INTO rank VALUES ('PETACMEM007', 'MEET0008', 'EVENT007', '15.9'); INSERT INTO rank VALUES ('PETACMEM010', 'MEET0008', 'EVENT001', '12.3'); //////////////////////////////////////////////////////////AD INSERT STATEMENTS/////////////////////////////////////////////////////////////////// INSERT INTO ad VALUES ('AD001', 'CAMBRIDGE AC SPORTS DAY AD'); INSERT INTO ad VALUES ('AD002', 'CAMBRIDGE AC ATHLETIC COMP AD'); INSERT INTO ad VALUES ('AD003', 'NORWICH AC SPORTS DAY AD'); INSERT INTO ad VALUES ('AD004', 'NORWICH AC ATHLETIC COMP AD'); INSERT INTO ad VALUES ('AD005', 'IPSWICH AC SPORTS EVENT AD'); INSERT INTO ad VALUES ('AD006', 'COLCHESTER AC SPORTS DAY AD'); INSERT INTO ad VALUES ('AD007', 'PETERBOROUGH AC SPORTS DAY AD'); INSERT INTO ad VALUES ('AD008', 'PETERBOROUGH AC ATHLETIC COMP AD'); //////////////////////////////////////////////////////MEETING_AD INSERT STATEMENTS////////////////////////////////////////////////////////////// INSERT INTO meeting_ad VALUES ('MEET0001', 'AD001'); INSERT INTO meeting_ad VALUES ('MEET0002', 'AD002'); INSERT INTO meeting_ad VALUES ('MEET0003', 'AD003'); INSERT INTO meeting_ad VALUES ('MEET0004', 'AD004'); INSERT INTO meeting_ad VALUES ('MEET0005', 'AD005'); INSERT INTO meeting_ad VALUES ('MEET0006', 'AD006'); INSERT INTO meeting_ad VALUES ('MEET0007', 'AD007'); INSERT INTO meeting_ad VALUES ('MEET0008', 'AD008'); /////////////////////////////////////////////////NEWSPAPER INSERT STATEMENTS////////////////////////////////////////////////////////////////////// INSERT INTO newspaper VALUES ('NEWS001', 'ANGLIAN TIMES', '01283210657', 'YES'); INSERT INTO newspaper VALUES ('NEWS002', 'CAMBRIDGE NEWS', '01564897124', 'NO'); INSERT INTO newspaper VALUES ('NEWS003', 'COLCHESTER MESSENGER', '01213854121', 'YES'); INSERT INTO newspaper VALUES ('NEWS004', 'NORWICH HERALD', '01290349746', 'NO'); INSERT INTO newspaper VALUES ('NEWS005', 'IPSWICH EAGLE', '01546908231', 'YES'); INSERT INTO newspaper VALUES ('NEWS006', 'PETERBOROUGH BUZZ', '01230980712', 'YES'); ///////////////////////////////////////////////////NEWSPAPER_AD INSERT STATEMENTS///////////////////////////////////////////////////////////// INSERT INTO newspaper_ad VALUES ('NEWS001', 'AD001'); INSERT INTO newspaper_ad VALUES ('NEWS001', 'AD002'); INSERT INTO newspaper_ad VALUES ('NEWS003', 'AD006'); INSERT INTO newspaper_ad VALUES ('NEWS004', 'AD003'); INSERT INTO newspaper_ad VALUES ('NEWS004', 'AD004'); INSERT INTO newspaper_ad VALUES ('NEWS005', 'AD005'); INSERT INTO newspaper_ad VALUES ('NEWS006', 'AD007'); INSERT INTO newspaper_ad VALUES ('NEWS006', 'AD008');