 -- settings
SET datestyle TO 'ISO, DMY';

-- create
CREATE TABLE CUSTOMER (
	Title TEXT NOT NULL,
	GivenName TEXT NOT NULL,
	FamilyName TEXT NOT NULL,
	CustomerNumber INTEGER PRIMARY KEY,
	StreetAddress TEXT NOT NULL,
	City TEXT NOT NULL,
	PostCode TEXT NOT NULL,
	EmailAddress TEXT NOT NULL,
	TelephoneNumber TEXT NOT NULL,
	Joined DATE NOT NULL,
	SessionJoined TEXT NOT NULL,
	Service TEXT NOT NULL,
	Price INTEGER NOT NULL
);

-- insert
INSERT INTO CUSTOMER VALUES ('Mrs', 'Sarah', 'Byrne', 218, '59 Duckpit Lane', 'UPPERMILL', 'PE3 7UZ', '[email protected]', '7870581375', '03-03-20', 'AM', 'A', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Isabelle', 'Perry', 224, '16 Gloddaeth Street', 'BILLINGBOROUGH', 'PE34 3LV', '[email protected]', '7858498759', '03-03-20', 'AM', 'A', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Maya', 'Abbott', 238, '22 Holgate Rd', 'RADCOT', 'PE18 0CG', '[email protected]', '7073933998', '03-03-20', 'AM', 'A', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Ethan', 'Cole', 264, '94 Boughton Rd', 'WHITSON', 'PE6 4BT', '[email protected]', '7052181531', '03-03-20', 'PM', 'A', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Eve', 'Hooper', 217, '74 Oxford Rd', 'WORSTEAD', 'PE28 5ZU', '[email protected]', '7923156309', '03-03-20', 'PM', 'E', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'William', 'Holden', 223, '20 High St', 'THORPE ST ANDREW', 'PE7 2JR', '[email protected]', '7864415451', '03-03-20', 'AM', 'E', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Callum', 'Walters', 236, '60 Princes Street', 'ROGIET', 'PE6 8PK', '[email protected]', '7017495722', '03-03-20', 'PM', 'E', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Poppy', 'Flynn', 254, '21 Kent Street', 'CROSS ASH', 'PE7 4DO', '[email protected]', '7758623404', '03-03-20', 'PM', 'E', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Logan', 'Parsons', 266, '18 Tonbridge Rd', 'CONISBY', 'PE49 0PP', '[email protected]', '7919421190', '03-03-20', 'PM', 'E', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Mohammad', 'Ali', 220, '6 Essex Rd', 'TASTON', 'PE7 4XH', '[email protected]', '7839208178', '03-03-20', 'AM', 'EA', 40);
INSERT INTO CUSTOMER VALUES ('Miss', 'Madison', 'Haynes', 235, '19 Scotsburn Rd', 'SYERSTON', 'PE23 6AX', '[email protected]', '7909577233', '02-03-20', 'AM', 'EA', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Emily', 'Rowe', 243, '23 Golf Road', 'SWAYFIELD', 'PE33 2SI', '[email protected]', '7082683508', '03-03-20', 'AM', 'EA', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Sam', 'Houghton', 265, '10 Seafield Street', 'LLECHRYD', 'PE2 1PC', '[email protected]', '7988208333', '03-03-20', 'AM', 'EA', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Erin', 'Taylor', 101, '59 Warren St', 'WEST FARNDON', 'NN11 0AU', '[email protected]', '7872264832', '02-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Hayden', 'Barrett', 117, '1 Union Terrace', 'LOCKERLEY', 'SO51 7TX', '[email protected]', '7065591238', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Melissa', 'Hope', 120, '55 Fordham Rd', 'HALLWORTHY', 'PL32 1TA', '[email protected]', '7038011183', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Reece', 'Barnes', 125, '41 Newport Road', 'CARISBROOKE', 'PO30 1PX', '[email protected]', '7745047773', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Alfie', 'Saunders', 132, '12 Old Edinburgh Road', 'BEECH HILL', 'RG7 8KQ', '[email protected]', '7047510765', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Elise', 'Townsend', 139, '31 Park Avenue', 'LEAKE COMMON SIDE', 'PE22 6XC', '[email protected]', '7781636464', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Matthew', 'Swift', 152, '38 Well Lane', 'PARKHILL', 'PH10 0YG', '[email protected]', '7019428838', '04-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Ruby', 'Bond', 159, '69 Overton Circle', 'LITTLETON DREW', 'SN14 5QD', '[email protected]', '7932032244', '03-05-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Kiera', 'Herbert', 168, '51 Roker Terrace', 'LANGRICK', 'PE22 8DZ', '[email protected]', '7851782855', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Jonathan', 'Clayton', 175, '19 Eastbourne Rd', 'COLDHARBOUR', 'RH5 7GJ', '[email protected]', '7975567910', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Aimee', 'Sykes', 188, '86 Temple Way', 'WITHAM ON THE HILL', 'PE10 9TQ', '[email protected]', '7954722088', '03-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Naomi', 'Murphy', 193, '32 Neville Street', 'IFIELD', 'RH11 8BA', '[email protected]', '7069171302', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Jacob', 'O-Brien', 197, '8 Iffley Road', 'BROADBRIDGE', 'PO18 0BQ', '[email protected]', '7733297632', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Ava', 'Cooke', 200, '48 Great North Road', 'ANDERBY', 'PE24 8QM', '[email protected]', '7925251993', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Finley', 'Osborne', 208, '52 Hounslow Rd', 'SNETTISHAM', 'PE31 2CL', '[email protected]', '7750315462', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Jennifer', 'Richardson', 212, '3 Newgate Street', 'KEAL COTES', 'PE23 7KE', '[email protected]', '7824948495', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Emily', 'Conlly', 221, '26 Winchester Rd', 'MICKLEHAM', 'RH5 1HR', '[email protected]', '7979446623', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Eva', 'Sims', 229, '56 Cefn Road', 'FARLEIGH WALLOP', 'RG25 3NH', '[email protected]', '7015757410', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Kai', 'Read', 239, '18 Rhosddu Rd', 'FINEGAND', 'PH10 7CE', '[email protected]', '7925046772', '04-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Harriet', 'Harris', 247, '23 Glandovey Terrace', 'TREMATON', 'PH12 1YI', '[email protected]', '7065363435', '04-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Aidan', 'Stevens', 251, '13 Abingdon Road', 'BRAMSHAW', 'SO43 6LF', '[email protected]', '7835560993', '03-05-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Kiera', 'Hardy', 255, '21 Ploughley Rd', 'TOFT', 'PE10 9XZ', '[email protected]', '7884299226', '03-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Millie', 'Whitehead', 262, '67 High Street', 'ASHE', 'RG25 2WH', '[email protected]', '7741348752', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Kate', 'Osborne', 272, '16 South Western Terrace', 'MILTON', 'PH8 6CR', '[email protected]', '7922213220', '04-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Brooke', 'Nelson', 275, '69 Main St', 'ACHNAHA', 'PH36 5RW', '[email protected]', '7852485719', '04-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Max', 'Collier', 106, '98 Great Western Road', 'LONGWORTH', 'OX13 5ZE', '[email protected]', '7924686469', '02-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Michael', 'Kemp', 113, '19 Roman Rd', 'LEDAIG', 'PE37 4OE', '[email protected]', '7002625667', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Georgia', 'Archer', 118, '65 Roman Rd', 'LEIGH', 'SY5 4ML', '[email protected]', '7835812580', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Harvey', 'John', 133, '68 Caradon Hill', 'TYNRIBBIE', 'PE38 4OU', '[email protected]', '7941128239', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Harrison', 'Leonard', 145, '73 Front Street', 'KNOWL WALL', 'ST4 3LQ', '[email protected]', '7938532929', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Samuel', 'Turner', 153, '43 Cefn Road', 'FARDEN', 'SY8 9GY', '[email protected]', '7913205640', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Alisha', 'Newman', 170, '79 Greyfriars Road', 'CAPEL DEWI', 'SA44 6UO', '[email protected]', '7041949176', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Alexandra', 'Thornton', 181, '30 Petworth Rd', 'DYFFRYN CEIDRYCH', 'SA19 9KP', '[email protected]', '7854361731', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Chloe', 'Williamson', 190, '52 Foregate Street', 'CLYNDERWEN', 'SA66 0QG', '[email protected]', '7889271480', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Tilly', 'Hall', 195, '35 St Omers Road', 'HIXON', 'ST18 0LW', '[email protected]', '7933293132', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Mohammed', 'Saleem', 202, '23 Boat Lane', 'REYNALTON', 'SA68 9BR', '[email protected]', '7731775770', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Taylor', 'O-Conr', 206, '90 Sutton Wick Lane', 'BRIDGEND', 'PE31 7GS', '[email protected]', '7857468870', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Aimee', 'Fitzgerald', 213, '20 Newgate Street', 'KEELE', 'ST5 2KB', '[email protected]', '7832429321', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Finlay', 'Miles', 241, '61 Great Western Road', 'LYDHAM', 'SY5 5DV', '[email protected]', '7065209517', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Kyle', 'Arld', 257, '64 Mar Way', 'GREAT SUTTON', 'SY8 8JU', '[email protected]', '7724642310', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Tilly', 'Able', 269, '67 Southend Avenue', 'BLACK PILL', 'SA3 1TC', '[email protected]', '7017857307', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Finley', 'Mills', 107, '41 Brynglas Road', 'GLENRISDELL', 'PA29 6PX', '[email protected]', '7738170693', '02-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Molly', 'Pickering', 111, '38 Earls Avenue', 'WHITESTAUNTON', 'SY20 3LG', '[email protected]', '7742110322', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Lucy', 'Chan', 124, '14 Prince Consort Road', 'KELSAY', 'PE47 3TC', '[email protected]', '7876442743', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Riley', 'Leonard', 137, '18 Lincoln Green Lane', 'CHRISHALL', 'SG8 3JM', '[email protected]', '7806616026', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Cerys', 'White', 151, '72 Main Road', 'AUDLEY', 'ST7 7YD', '[email protected]', '7913688831', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Phoebe', 'Hargreaves', 156, '73 Simone Weil Avenue', 'WELL END', 'SL8 4PZ', '[email protected]', '7708234050', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Daniel', 'Barber', 162, '39 South Crescent', 'LYDHAM', 'SY9 8NF', '[email protected]', '7850934810', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Oscar', 'Giles', 176, '51 Gordon Terrace', 'BAUGH', 'PE77 8CE', '[email protected]', '7020855076', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Patrick', 'Walters', 187, '36 Iffley Road', 'BRIZE NORTON', 'OX18 4QM', '[email protected]', '7757246673', '02-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Katherine', 'Slater', 189, '36 Shire Oak Road', 'SCALASAIG', 'PE61 9II', '[email protected]', '7048724521', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Niamh', 'Holland', 204, '29 Ballifeary Road', 'BALNAHARD', 'PE61 7NS', '[email protected]', '7744056335', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Robert', 'Noble', 219, '4 Front Street', 'KNYPERSLEY', 'ST8 2ZC', '[email protected]', '7870725844', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Tom', 'Ryan', 227, '77 Colorado Way', 'RHOSSILI', 'SA3 2YI', '[email protected]', '7858287133', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Emma', 'Hughes', 231, '74 Rhosddu Rd', 'FFAIR-RHOS', 'SY25 8HR', '[email protected]', '7712531185', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Evan', 'O-Sullivan', 270, '58 Holburn Lane', 'HEATON MOOR', 'SK4 2NM', '[email protected]', '7055670639', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Lydia', 'Sykes', 100, '59 Exning Road', 'HARFORD', 'PH21 7XC', '[email protected]', '7951995552', '04-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Connor', 'Chamberlain', 104, '43 Traill Street', 'ROTHERSTHORPE', 'NN7 8BM', '[email protected]', '7833983220', '02-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Henry', 'Davison', 109, '16 Souterhead Road', 'LOSTWITHIEL', 'PH22 6HN', '[email protected]', '7871538251', '04-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Hannah', 'Fleming', 114, '75 Ballifeary Road', 'BAMBER BRIDGE', 'PR5 0TU', '[email protected]', '7022870252', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Aaron', 'Morris', 126, '79 Hampton Court Rd', 'SOUTHORPE', 'PE9 1QH', '[email protected]', '7767425279', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Lady', 'Victoria', 'Taylor', 130, '55 St Omers Road', 'HOCKLEY', 'SS5 3OB', '[email protected]', '7708342029', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Amelia', 'Power', 135, '13 Prospect Hill', 'DRAYCOTT IN THE MOORS', 'ST10 2KL', '[email protected]', '7000374273', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Laura', 'Kelly', 142, '91 Davids Lane', 'STRONE', 'PH33 6AS', '[email protected]', '7917583320', '04-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Eleanor', 'Edwards', 147, '68 Preston Rd', 'MORFA GLAS', 'SA11 6NU', '[email protected]', '7986126560', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Libby', 'West', 149, '67 Jesmond Rd', 'KILMALIEU', 'PH33 1ML', '[email protected]', '7906286095', '04-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Sarah', 'Vincent', 158, '27 Botley Road', 'MIDDLETON GREEN', 'ST10 7CZ', '[email protected]', '7852805525', '06-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Archie', 'Davey', 161, '5 Bootham Crescent', 'RING-S END', 'PE13 4AN', '[email protected]', '7035770108', '03-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Josh', 'Reeves', 165, '67 Cambridge Road', 'NORTH ANSTON', 'S31 7CG', '[email protected]', '7035076899', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Connor', 'Dean', 169, '23 Hendford Hill', 'MOULTON', 'NN3 9BC', '[email protected]', '7822483787', '02-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Lewis', 'Marshall', 178, '52 Felix Lane', 'SIBSEY', 'PE22 5AI', '[email protected]', '7780936968', '03-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Summer', 'Bryant', 180, '69 Petworth Rd', 'DUTHIL', 'PH23 9FU', '[email protected]', '7803104726', '04-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Brooke', 'Allan', 184, '16 Fordham Rd', 'HAIGHTON GREEN', 'PR2 1VQ', '[email protected]', '7920356485', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Summer', 'Johnston', 196, '47 Fulford Road', 'PENTEWAN', 'PH26 8DG', '[email protected]', '7936888546', '04-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Ellis', 'Alexander', 211, '94 Abbey Row', 'NORWICH', 'NR2 8MH', '[email protected]', '7884388944', '02-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Jake', 'Baker', 228, '95 Peachfield Road', 'CHALE', 'PO38 0QH', '[email protected]', '7011814720', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Holly', 'Johnson', 234, '54 Redcliffe Way', 'WOOLLEY', 'PE18 6HN', '[email protected]', '7789298855', '03-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Finlay', 'Bolton', 240, '13 Ivy Lane', 'WARBOYS', 'PE17 2QE', '[email protected]', '7749289904', '03-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Elizabeth', 'Ingram', 245, '5 Earls Avenue', 'WHITELEY BANK', 'PO38 1RG', '[email protected]', '7985916287', '05-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Ms', 'Gracie', 'Crawford', 249, '98 High St', 'THRYBERGH', 'S65 7ZW', '[email protected]', '7908149967', '05-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr', 'Kieran', 'Johnston', 260, '50 Cloch Rd', 'ST MARTINS', 'PH2 5MR', '[email protected]', '7728278866', '04-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Mia', 'Young', 261, '16 Eastbourne Rd', 'COLDEN COMMON', 'SO21 8MH', '[email protected]', '7716040826', '06-03-20', 'AM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Miss', 'Ella', 'Robson', 268, '97 Preston Rd', 'MORBORNE', 'PE7 2KG', '[email protected]', '7058791557', '03-03-20', 'PM', 'G', 25);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Hayden', 'Gibson', 116, '47 Roman Rd', 'LECKFORD', 'SO20 3WW', '[email protected]', '7857694692', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Aaron', 'Rhodes', 119, '11 Glandovey Terrace', 'TRESINNEY', 'PL32 9XJ', '[email protected]', '7800650838', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Robert', 'Lawson', 122, '41 Berkeley Rd', 'STRATFORD TONY', 'SP5 8FG', '[email protected]', '7031796652', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Erin', 'Kerr', 131, '10 South Street', 'MONCREIFFE', 'PH2 5AV', '[email protected]', '7029617150', '04-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Luke', 'Murray', 136, '6 St Andrews Lane', 'DALCHRUIN', 'PH6 3EP', '[email protected]', '7848256668', '04-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Harvey', 'Hall', 141, '74 Redcliffe Way', 'WOOLSTONE', 'SN7 0CN', '[email protected]', '7775817951', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'William', 'Hughes', 155, '81 South Street', 'MONXTON', 'SP11 0ST', '[email protected]', '7903394553', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Cameron', 'Stokes', 163, '63 Consett Rd', 'HILL *****', 'PE22 5VW', '[email protected]', '7005869342', '03-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Miss', 'Scarlett', 'Coles', 173, '47 Clasper Way', 'HICKLING GREEN', 'NR12 6IZ', '[email protected]', '7010893878', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Demi', 'Byrne', 186, '46 Ross Road', 'MARTIN', 'SP6 3XY', '[email protected]', '7863629104', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Sebastian', 'Bartlett', 192, '18 Tadcaster Rd', 'PILLATON', 'PH12 8NN', '[email protected]', '7888609105', '04-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Sean', 'Pugh', 194, '45 Foregate Street', 'COED-Y-PAEN', 'NP4 5UY', '[email protected]', '7939087067', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Zoe', 'Howarth', 199, '52 Farburn Terrace', 'LITTLE LONDON', 'PE12 5IV', '[email protected]', '7867851797', '03-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Corey', 'Joyce', 205, '29 Eastbourne Rd', 'COLD ASHTON', 'SN14 3HO', '[email protected]', '7918170220', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Declan', 'Vaughan', 210, '87 Ploughley Rd', 'TINTERN PARVA', 'NP6 8HW', '[email protected]', '7955999534', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'William', 'Naylor', 216, '49 Guildry Street', 'GAMSTON', 'NG2 0KP', '[email protected]', '7774495498', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Jonathan', 'Naylor', 222, '81 Coast Rd', 'KIRKBY UNDERWOOD', 'PE10 8CT', '[email protected]', '7755676839', '03-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Scarlett', 'Marshall', 233, '99 Dunmow Road', 'GRISHIPOLL', 'PE10 7CT', '[email protected]', '7801988036', '03-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Luca', 'Browne', 242, '14 Sea Road', 'LANDFORD', 'SP5 3QU', '[email protected]', '7941118238', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Joshua', 'Jarvis', 250, '43 Asfordby Rd', 'AIRNTULLY', 'PH1 8SG', '[email protected]', '7006180022', '04-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Laura', 'Tomlinson', 253, '81 Sutton Wick Lane', 'BRINKWORTH', 'SN15 4IV', '[email protected]', '7080858576', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Sean', 'Chadwick', 256, '30 Shore Street', 'STOKE', 'PO11 5JA', '[email protected]', '7917845782', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Eloise', 'Lee', 267, '81 Davids Lane', 'STRONTIAN', 'PH36 4ED', '[email protected]', '7776536855', '04-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Mason', 'Marsh', 273, '87 Emerson Road', 'KINROSSIE', 'PH2 4NJ', '[email protected]', '7732161852', '04-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Miss', 'Faith', 'Hammond', 110, '12 Simone Weil Avenue', 'WAUN Y CLYN', 'SA17 7TB', '[email protected]', '7852376534', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Toby', 'Hewitt', 115, '74 Boat Lane', 'REPPS', 'NR29 4RA', '[email protected]', '7847012074', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Chloe', 'White', 127, '36 Huntly Street', 'BARRAHORMID', 'PE31 8JL', '[email protected]', '7878351699', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'William', 'Nicholls', 144, '45 Nottingham Rd', 'ABERCRYCHAN', 'SA20 9RZ', '[email protected]', '7954258613', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Tom', 'Shaw', 146, '36 Prestwick Road', 'INISTRYNICH', 'PE33 2DI', '[email protected]', '7748545932', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Phoebe', 'Kent', 167, '24 Prospect Hill', 'DRE-FACH', 'SA40 0CM', '[email protected]', '7041668722', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Tom', 'Atkins', 172, '98 Roman Rd', 'LEIGH', 'SY5 4LW', '[email protected]', '7978710349', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Daniel', 'Baker', 183, '2 Stamford Road', 'ARDANSTUR', 'PE34 6CW', '[email protected]', '7787219509', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Mohammed', 'McDonald', 191, '95 Earls Avenue', 'WHITECHURCH', 'SA41 6GO', '[email protected]', '7747284510', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Elizabeth', 'Townsend', 201, '36 Overton Circle', 'LITTLEBOROUGH', 'OL15 1LT', '[email protected]', '7969031411', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Cameron', 'Tucker', 203, '30 Scrimshire Lane', 'ASTON', 'SY8 3OU', '[email protected]', '7051599731', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Lydia', 'Johnston', 209, '4 Dunmow Road', 'GRINDLEY', 'ST14 8NP', '[email protected]', '7982033727', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Declan', 'Ingram', 225, '98 Guild Street', 'LONDON', 'SE17 8QX', '[email protected]', '7773050104', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Deepak', 'Singh', 246, '97 Neville Street', 'HYDE LEA', 'ST18 6FK', '[email protected]', '7974040380', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Phoebe', 'Hardy', 259, '35 Rhosddu Rd', 'FFAIRFACH', 'SA19 0QD', '[email protected]', '7837507087', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Anthony', 'Wyatt', 102, '41 Park Place', 'CASSINGTON', 'OX8 4WK', '[email protected]', '7754053369', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Evan', 'Kemp', 108, '78 South Crescent', 'LYDEARD ST LAWRENCE', 'SY4 8UW', '[email protected]', '7076303448', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Lucas', 'Bates', 123, '52 Graham Road', 'CHERITON', 'SA3 7AM', '[email protected]', '7852902116', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Riley', 'Chapman', 129, '27 Iffley Road', 'BROADOAK', 'SA32 4ZW', '[email protected]', '7756302998', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Freya', 'Harris', 138, '79 Friar Street', 'CLATTER', 'SY17 2YE', '[email protected]', '7052335073', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Abbie', 'Day', 154, '65 Northgate Street', 'BETTWS EVAN', 'SA38 1YW', '[email protected]', '7711606538', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Tyler', 'Bradshaw', 157, '9 Long Street', 'MILE ELM', 'SN11 6EP', '[email protected]', '7046582650', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Leo', 'Fox', 171, '53 Front St', 'HENLEY', 'SY10 9HU', '[email protected]', '7820429138', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Melissa', 'Daly', 177, '72 Fore St', 'TROUSTAN', 'PA22 3XG', '[email protected]', '7013713577', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Victoria', 'Jarvis', 198, '68 High St', 'THURLBEAR', 'SY3 0CN', '[email protected]', '7718763067', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Rebecca', 'Howells', 215, '45 Ramsgate Rd', 'WILLIAN', 'SG6 3BR', '[email protected]', '7712864980', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Henry', 'Lloyd', 226, '25 Scotsburn Rd', 'TALYBONT', 'SY24 2AA', '[email protected]', '7074127628', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Emily', 'Peacock', 230, '31 Seafield Street', 'LLANYBRI', 'SA33 4EM', '[email protected]', '7088587824', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Kian', 'Dyer', 252, '41 St James Boulevard', 'HORSE BRIDGE', 'ST9 8IW', '[email protected]', '7024058328', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Mohammad', 'Akhtar', 271, '25 High St', 'THREE CROSSES', 'SA4 4CV', '[email protected]', '7025577492', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Lord', 'Jack', 'Naylor', 103, '11 Seafield Place', 'FORNCETT ST MARY', 'NR16 6KQ', '[email protected]', '7787729363', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr ', 'Peter', 'Williams', 105, '87 Withers Close', 'ALDWINCLE', 'NN14 5UC', '[email protected]', '7046656756', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Corey', 'Ball', 112, '10 Marlborough Crescent', 'SOUTHGATE', 'PE31 8MJ', '[email protected]', '7815760068', '03-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Connor', 'Dean', 121, '30 Sutton Wick Lane', 'BRINGTON', 'PE18 4OJ', '[email protected]', '7877420620', '03-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Grace', 'Frost', 128, '58 Southlands Road', 'PONTNEWYNYDD', 'NP4 3QY', '[email protected]', '7822101945', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Miss', 'Madeleine', 'Sinclair', 134, '61 Greble Road', 'BRAY SHOP', 'PH17 1JE', '[email protected]', '7850968359', '04-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Katie', 'Hart', 140, '76 Annfield Rd', 'BEDHAMPTON', 'PO9 2NK', '[email protected]', '7088010157', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'William', 'James', 143, '27 Baldock Street', 'NEWTONMORE', 'PH20 8HN', '[email protected]', '7040835079', '04-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Naomi', 'Matthews', 148, '90 Witney Way', 'KITWOOD', 'SO24 8FK', '[email protected]', '7921921434', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Peter', 'Bailey', 150, '62 Chapel Lane', 'ARMINGHALL', 'NR14 8QF', '[email protected]', '7055573640', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Aidan', 'Power', 160, '48 Baldock Street', 'NEWTON STACEY', 'SO20 8SB', '[email protected]', '7826902613', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Miss', 'Madeleine', 'Conr', 164, '74 Broad Street', 'LOWER WIELD', 'SO24 7JD', '[email protected]', '7850454256', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Naomi', 'Bray', 166, '39 Stroud Rd', 'OLD BUCKENHAM', 'NR17 3XF', '[email protected]', '7772610703', '02-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Ruby', 'Fuller', 174, '77 Tadcaster Rd', 'PIPEWELL', 'NN14 3RX', '[email protected]', '7033070974', '02-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Sebastian', 'Perkins', 179, '26 Golf Road', 'SWAFFHAM', 'PE37 7OH', '[email protected]', '7732847494', '03-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Henry', 'Barlow', 182, '95 Seafield Place', 'FORSBROOK', 'ST11 2RA', '[email protected]', '7784388863', '06-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Dominic', 'Doyle', 185, '21 Peachfield Road', 'CEFNEITHIN', 'SA14 7AC', '[email protected]', '7709130328', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Jayden', 'Martin', 207, '48 Scarcroft Road', 'POPHAM', 'SO21 9PD', '[email protected]', '7976886166', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Erin', 'James', 214, '7 Abingdon Road', 'BRAMDEAN', 'SO24 1MK', '[email protected]', '7001626279', '06-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Lewis', 'Hayward', 232, '15 Scrimshire Lane', 'ASTON', 'S30 0HW', '[email protected]', '7809175132', '05-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Ms', 'Matilda', 'Hunt', 237, '77 Broomfield Place', 'STOW BARDOLPH', 'PE34 2SU', '[email protected]', '7822934583', '03-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Evan', 'Hooper', 244, '19 St Dunstans Street', 'WATERLOOVILLE', 'PO7 2PL', '[email protected]', '7923304355', '05-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Tegan', 'Turnbull', 248, '8 Sutton Wick Lane', 'BRIDGETOWN', 'PH15 9AY', '[email protected]', '7820332767', '04-03-20', 'PM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Bailey', 'Webb', 258, '90 Cloch Rd', 'ST IVES', 'PE17 6WN', '[email protected]', '7911276164', '03-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mr', 'Kyle', 'Fry', 263, '31 Ings Lane', 'DAVA', 'PH26 7GE', '[email protected]', '7026417141', '04-03-20', 'AM', 'GE', 40);
INSERT INTO CUSTOMER VALUES ('Mrs', 'Georgia', 'Watts', 274, '69 Cheriton Rd', 'WEST ORCHARD', 'SP7 8AF', '[email protected]', '7924729729', '06-03-20', 'PM', 'GE', 40);
SELECT 
  count(EmailAddress)
FROM
  CUSTOMER
WHERE
  EmailAddress LIKE 'dodgit%'

created 2 years ago

PostgreSQL online editor

Write, Run & Share PostgreSQL queries online using OneCompiler's PostgreSQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for PostgreSQL. Getting started with the OneCompiler's PostgreSQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose database as 'PostgreSQL' and start writing queries to learn and test online without worrying about tedious process of installation.

About PostgreSQL

PostgreSQL is a open source relational database system and is also knows as Postgres.

Key Features:

Postgres is not only free and open-source but also it is highly extensible.
Custom Data types and funtions from various programming languaues can be introduced and the good part is compiling entire database is not required.
ACID(Atomicity, Consistency, Isolation, Durability) compliant.
First DBMS which implemented Multi-version concurrency control (MVCC) feature.
It's the default database server for MacOS.
It supports all major operating systems like Linux, Windows, OpenBSD,FreeBSD etc.

Syntax help

1. CREATE

CREATE command is used to create a table, schema or an index.

Syntax:

         CREATE TABLE table_name (
                column1 datatype,
                column2 datatype,
                ....);

2. ALTER

ALTER command is used to add, modify or delete columns or constraints from the database table.

Syntax

ALTER TABLE Table_name ADD column_name datatype;

3. TRUNCATE:

TRUNCATE command is used to delete the data present in the table but this will not delete the table.

Syntax

TRUNCATE table table_name;

4. DROP

DROP command is used to delete the table along with its data.

Syntax

DROP TABLE table_name;

5. RENAME

RENAME command is used to rename the table name.

Syntax

ALTER TABLE table_name1 RENAME to new_table_name1;

6. INSERT

INSERT Statement is used to insert new records into the database table.

Syntax

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

7. SELECT

Select statement is used to select data from database tables.

Syntax:

SELECT column1, column2, ...
FROM table_name;

8. UPDATE

UPDATE statement is used to modify the existing values of records present in the database table.

Syntax

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

9. DELETE

DELETE statement is used to delete the existing records present in the database table.

Syntax

DELETE FROM table_name where condition;