ADD SAMPLE DATA TO CUSTOMERS TABLE

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000001, ‘JOHN’, ‘SMITH’, ‘1957-10-01’, ‘M’, ‘US’, ‘R’, 07985198754074, ‘1997-02-21’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000002, ‘WILL’, ‘SMITH’, ‘1977-11-21’, ‘M’, ‘US’, ‘R’, 07998199754083, ‘2017-02-21’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000003, ‘JACK’, ‘SPARROW’, ‘1987-01-03’, ‘M’, ‘AU’, ‘V’, 05485198754062, ‘2017-03-21’, ‘N’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000004, ‘HILLARY’, ‘CLINTON’, ‘1966-04-09’, ‘F’, ‘CA’, ‘R’, 090851987540732, ‘1999-05-30’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000005, ‘TONY’, ‘BLAIR’, ‘1989-08-23’, ‘M’, ‘EN’, ‘V’, 08585198754099, ‘2015-06-21’, ‘D’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000006, ‘LIONEL’, ‘MESSI’, ‘1998-08-22’, ‘M’, ‘AR’, ‘V’, 07685198754088, ‘2017-01-21’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000007, ‘NEYMAR’, ‘JUNIOR’, ‘1998-09-17’, ‘M’, ‘BR’, ‘V’, 07585198754045, ‘2017-01-21’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000008, ‘GWEN’, ‘STEFANI’, ‘1979-07-14’, ‘F’, ‘CA’, ‘R’, 09085198754584, ‘2011-07-13’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (525000000009, ‘MARGARETH’, ‘BROOKS’, ‘1987-08-16’, ‘F’, ‘CA’, ‘V’, 09085198754874, ‘2013-05-17’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (788000000001, ‘CAROLYN’, ‘DOE’, ‘1987-04-04’, ‘F’, ‘CA’, ‘R’, 09085198754555, ‘2016-02-25’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (788000000002, ‘JOANNE’, ‘GELLAR’, ‘1988-11-04’, ‘F’, ‘CA’, ‘R’, 09098199754333, ‘2016-11-21’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (788000000003, ‘JACK’, ‘BROWN’, ‘1979-01-31’, ‘M’, ‘CA’, ‘R’, 09085198754062, ‘2017-03-21’, ‘N’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (788000000004, ‘BILL’, ‘CLINTON’, ‘1956-04-09’, ‘M’, ‘CA’, ‘R’, 090851987540832, ‘2016-05-30’, ‘A’);

 

INSERT INTO CUSTOMERS (CUSTOMERID, FIRSTNAME, LASTNAME, DATEOFBIRTH, GENDER, NATIONALITY, RESIDENCYSTATUS, ID_NUMBER, REGISTRATIONDATE, VERIFICATIONSTATUS)

VALUES (788000000005, ‘PABLO’, ‘FREITAS’, ‘1989-08-15’, ‘M’, ‘AR’, ‘V’, 07685198754222, ‘2016-11-21’, ‘D’);