-- DATABASE MANAGEMENT SYSTEMS 2019/20
-- LAB EXERCISE 4
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

/*
	Make sure you have created your database first
	I recommend running the queries for each table one by one unless you are absolutely sure your tables have been created properly :)
	Try the first insert for a table, if it works then run the others
	
	I have included the delete commands for each table in comments in case you need to delete the data and re-run the insert commands
*/

--USE [Master]
--GO

---- REPLACE as required with your student number
--USE DreamHome_REPLACE_WITH_YOUR_STUDENT_NUMBER
--GO


/* Insert Data INTO Branch */

-- DELETE FROM Branch

INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0001', 'Mount Pleasant', 'Swansea', 'SA1 6ED', '01792400000')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0002', '18 Kingsway', 'Lampeter', 'SA48 1BQ', '01571000000')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0003', '47 Albert Road', 'Carmarthen', 'SA33 9NS', '01267123456')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0005', '56 Cover Drive', 'London', 'NW10 6EU', '02087700001')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0006', '163 Main Street', 'Glasgow', 'G11 9QX', '01419910000')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0007', '32 Manse Road', 'Bristol', 'BS99 1NZ', '01172123456')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0008', '22 Deer Road', 'London', 'SW1 4EH', '02079150000')
INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) VALUES ('B0009', '16 Argyll Street', 'Aberdeen', 'AB2 3SU', '01224500000')



GO

/* Insert Data INTO Staff */

-- DELETE FROM Staff

INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29010', 'Grace', 'Hargrave', 'Female', '06-Nov-1958', 'Supervisor', 26000, '02-Apr-2019', 'B0008', NULL, 'Grace.Hargrave@dreamhome.co.uk', '07893936937')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29002', 'Molly', 'Lancaster', 'Female', '24-Sep-1987', 'Manager', 28000, '22-Mar-2019', 'B0002', NULL, 'Molly.Lancaster@dreamhome.co.uk', '07917297119')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29004', 'Adrian', 'Brooks', 'Male', '16-Nov-1990', 'Manager', 32000, '30-Jun-2019', 'B0001', NULL, 'Adrian.Brooks@dreamhome.co.uk', '07143554365')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29006', 'Layla', 'Harris', 'Female', '27-Oct-1967', 'Manager', 33000, '23-May-2019', 'B0007', NULL, 'Layla.Harris@dreamhome.co.uk', '07673017591')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29007', 'Xavier', 'Hollands', 'Prefer not to say', '12-Jul-1961', 'Manager', 35000, '16-Apr-2019', 'B0006', NULL, 'Xavier.Hollands@dreamhome.co.uk', '07967047396')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S28014', 'Oliver', 'Smith', 'Male', '13-Feb-1955', 'Manager', 30000, '28-Dec-2018', 'B0009', NULL, 'Oliver.Smith@dreamhome.co.uk', '07796360877')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S28018', 'Brianna', 'Harris', 'Female', '22-Dec-1999', 'Manager', 33000, '17-Nov-2018', 'B0003', NULL, 'Brianna.Harris@dreamhome.co.uk', '07321393498')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29019', 'Lauren', 'Stuart', 'Female', '29-Jul-1969', 'Manager', 29000, '24-Jun-2019', 'B0005', NULL, 'Lauren.Stuart@dreamhome.co.uk', '07751969341')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S28013', 'Peyton', 'Frankland', 'Female', '11-Jan-1955', 'Assistant', 17000, '24-Dec-2018', 'B0008', 'S29010', 'Peyton.Frankland@dreamhome.co.uk', '07889482494')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29011', 'Melanie', 'Scott', 'Unspecified', '25-Mar-1956', 'Supervisor', 24000, '28-Jun-2019', 'B0001', 'S29004', 'Melanie.Scott@dreamhome.co.uk', '07884761960')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S28012', 'Faith', 'Sanger', 'Female', '23-Sep-1965', 'Assistant', 18000, '19-Nov-2018', 'B0001', 'S29011', 'Faith.Sanger@dreamhome.co.uk', '07872978278')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29001', 'Blake', 'Harper', 'Male', '08-Jun-1965', 'Assistant', 19000, '02-Feb-2019', 'B0001', 'S29011', 'Blake.Harper@dreamhome.co.uk', '07363055417')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29008', 'Nathan', 'Worden', 'Male', '09-Sep-1995', 'Supervisor', 24000, '06-Sep-2019', 'B0002', 'S29002', 'Nathan.Worden@dreamhome.co.uk', '07174995953')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29015', 'Nolan', 'Brooks', 'Male', '02-Aug-1996', 'Assistant', 16000, '13-May-2019', 'B0007', 'S29006', 'Nolan.Brooks@dreamhome.co.uk', '07707921288')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S28005', 'Isaiah', 'Harper', 'Male', '31-Aug-1990', 'Assistant', 18000, '08-Dec-2018', 'B0002', 'S29008', 'Isaiah.Harper@dreamhome.co.uk', '07845090573')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29016', 'Claire', 'Chilcott', 'Female', '12-Dec-1997', 'Supervisor', 27000, '01-Jun-2019', 'B0003', 'S28018', 'Claire.Chilcott@dreamhome.co.uk', '07835661904')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S28003', 'Gianna', 'Wear', 'Female', '08-Aug-1990', 'Assistant', 17000, '25-Dec-2018', 'B0003', 'S29016', 'Gianna.Wear@dreamhome.co.uk', '07503524741')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29017', 'Jasmine', 'Stockholm', 'Female', '29-Nov-1983', 'Assistant', 17000, '18-Jan-2019', 'B0003', 'S29016', 'Jasmine.Stockholm@dreamhome.co.uk', '07168903452')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29009', 'Charlotte', 'Campbell', 'Female', '02-May-1971', 'Assistant', 19000, '03-Mar-2019', 'B0005', 'S29019', 'Charlotte.Campbell@dreamhome.co.uk', '07816455165')
INSERT INTO Staff (StaffNo, FirstName, LastName, Gender, DOB, Position, Salary, StartDate, BranchNo, SupervisorStaffNo, Email, Mobile) VALUES ('S29020', 'Zachary', 'Ellis', 'Male', '21-Mar-1974', 'Assistant', 17000, '28-Mar-2019', 'B0005', 'S29019', 'Zachary.Ellis@dreamhome.co.uk', '07662756920')



GO



/* Insert Data INTO BranchManager */

-- DELETE FROM BranchManager

INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0001', 'S29004', '30-Jun-2019', NULL, 2350)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0002', 'S29002', '22-Mar-2019', NULL, 1550)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0003', 'S28018', '17-Nov-2018', NULL, 2000)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0005', 'S29019', '24-Jun-2019', NULL, 3000)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0006', 'S29007', '16-Apr-2019', NULL, 2250)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0007', 'S29006', '23-May-2019', NULL, 2500)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0008', 'S29010', '02-Apr-2019', NULL, 2890)
INSERT INTO BranchManager (BranchNo, StaffNo, StartDate, EndDate, Bonus) VALUES ('B0009', 'S28014', '28-Dec-2018', NULL, 2350)



GO

/* Insert Data INTO Owner */

-- DELETE FROM [Owner]

INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19028', 'Autumn', 'Holiday', 'University of Wales Trinity Saint David', 'Education', 'Kings Road', 'Swansea', 'SA1 8EW', '07623541027', 'Autumn.Holiday@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19048', 'Trinity', 'Geary', NULL, NULL, '2 York Road', 'Carmarthen', 'SA33 7DL', '07275137058', 'S.Geary@somedomain.co.uk', 'trinity')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19007', 'Jackson', 'Tomlison', NULL, NULL, '42 George Street', 'Neath', 'SA10 6EA', '07300671226', 'Jackson.Tomlison@myemaildomain.com', 'tomlison')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19051', 'Emily', 'Paton', NULL, NULL, '36 North Street', 'Swansea', 'SA1 1JF', '07904694732', 'S.Paton@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19026', 'Josiah', 'Jones', NULL, NULL, '43 The Grove', 'Swansea', 'SA1 2YG', '07589941486', 'Josiah.Jones@myemaildomain.com', 'josiah')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19014', 'Audrey', 'Freeman', NULL, NULL, '16 Station Road', 'Swansea', 'SA2 7KE', '07131172866', 'S.Freeman@somedomain.co.uk', 'freeman')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19018', 'Ella', 'Carr', NULL, NULL, '37 Church Street', 'Swansea', 'SA2 0KM', '07845580553', 'Ella.Carr@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19035', 'Michael', 'Middleton', 'XYZ Computers', 'IT', '46 New Road', 'Neath', 'SA10 6TX', '07190842108', 'S.Middleton@somedomain.co.uk', 'michael')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19040', 'Gabriella', 'Dewhurst', NULL, NULL, '14 Kings Road', 'Carmarthen', 'SA32 0SF', '07638725241', 'Gabriella.Dewhurst@myemaildomain.com', 'dewhurst')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19025', 'Matthew', 'Pendry', NULL, NULL, '10 King Street', 'Lampeter', 'SA48 3TI', '07118880248', 'S.Pendry@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19037', 'Christian', 'Varghese', NULL, NULL, '26 Manor Road', 'Lampeter', 'SA48 2VM', '07916281381', 'Christian.Varghese@myemaildomain.com', 'christian')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19033', 'James', 'Joe', NULL, NULL, '46 The Crescent', 'Swansea', 'SA1 1PF', '07913886879', 'S.Joe@somedomain.co.uk', 'joe')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19022', 'Carlos', 'Hayden', NULL, NULL, '16 Highfield Road', 'Swansea', 'SA2 0NZ', '07126778251', 'Carlos.Hayden@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19038', 'Ella', 'Bowen', '123 Foods', 'Manufacturing', '22 King Street', 'Carmarthen', 'SA33 6OX', '07479973474', 'S.Bowen@somedomain.co.uk', 'ella')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19016', 'Jack', 'Harding', NULL, NULL, '45 The Green', 'Neath', 'SA10 5ZE', '07796313376', 'Jack.Harding@myemaildomain.com', 'harding')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19013', 'Stella', 'Scott', NULL, NULL, '2 Church Lane', 'Swansea', 'SA1 0CA', '07873137788', 'S.Scott@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19020', 'Hunter', 'Dabbs', NULL, NULL, '1 Windsor Road', 'Neath', 'SA10 9PC', '07716892172', 'Hunter.Dabbs@myemaildomain.com', 'hunter')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19046', 'Christian', 'Logan', NULL, NULL, '34 Main Road', 'Swansea', 'SA1 9WU', '07582433762', 'S.Logan@somedomain.co.uk', 'logan')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19015', 'Jocelyn', 'Whitelock', NULL, NULL, '5 High Street', 'Head District', 'N1 1PZ', '07951761733', 'Jocelyn.Whitelock@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19045', 'Alexa', 'Ernest', NULL, NULL, '37 Park Avenue', 'East Finchley', 'N2 7GG', '07513729061', 'N.Ernest@somedomain.co.uk', 'alexa')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19024', 'Madeline', 'Pinegar', NULL, NULL, '32 Queens Road', 'Leyton', 'E10 0FY', '07580945994', 'Madeline.Pinegar@myemaildomain.com', 'pinegar')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19039', 'Makayla', 'Law', NULL, NULL, '18 Windsor Road', 'Homerton', 'E9 8ZY', '07397456563', 'E.Law@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19047', 'Adam', 'Carr', NULL, NULL, '21 King Street', 'Bow', 'E3 1IJ', '07430086515', 'Adam.Carr@myemaildomain.com', 'adam')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19044', 'Ian', 'Moxley', NULL, NULL, '6 Park Avenue', 'Walthamstow', 'E17 6KI', '07468613262', 'E.Moxley@somedomain.co.uk', 'moxley')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19034', 'Connor', 'Turner', NULL, NULL, '14 Queens Road', 'Stratford', 'E15 5JZ', '07726855130', 'Connor.Turner@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19031', 'Oliver', 'Geary', NULL, NULL, '19 Mill Lane', 'Homerton', 'E9 7CG', '07259989296', 'E.Geary@somedomain.co.uk', 'oliver')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19019', 'Emily', 'Campbell', 'ABC Company', 'Manufacturing', '48 Green Lane', 'Fenchurch Street', 'EC3 4FU', '07647840456', 'Emily.Campbell@myemaildomain.com', 'campbell')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19052', 'Ayden', 'Pinegar', NULL, NULL, '9 Park Avenue', 'Victoria Docks', 'E16 5XO', '07423856979', 'E.Pinegar@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19049', 'Sophia', 'Paton', NULL, NULL, '21 Kingsway', 'Fenchurch Street', 'EC3 0BC', '07212612796', 'Sophia.Paton@myemaildomain.com', 'sophia')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19043', 'Sydney', 'Huckle', NULL, NULL, '4 King Street', 'Olympic Park', 'E20 7OI', '07864081850', 'E.Huckle@somedomain.co.uk', 'huckle')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19008', 'Naomi', 'Mayson', NULL, NULL, '22 George Street', 'Bristol', 'BS8 3EH', '07545407597', 'Naomi.Mayson@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19021', 'Joseph', 'Zatarain', NULL, NULL, '29 New Street', 'Bristol', 'BS30 6ZU', '07349809415', 'B.Zatarain@somedomain.co.uk', 'joseph')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19006', 'Samuel', 'Abbs', NULL, NULL, '26 The Grove', 'Bristol', 'BS6 2QN', '07257527817', 'Samuel.Abbs@myemaildomain.com', 'abbs')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19042', 'Tyler', 'Freeman', NULL, NULL, '12 StreetName', 'Winscombe', 'BS25 7YR', '07800671553', 'B.Freeman@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19003', 'Isaac', 'Burt', NULL, NULL, '1 Green Lane', 'Bristol', 'BS5 8MR', '07454507313', 'Isaac.Burt@myemaildomain.com', 'isaac')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19030', 'Lydia', 'Puddy', NULL, NULL, '1 New Road', 'Bristol', 'BS13 9VK', '07141649653', 'B.Puddy@somedomain.co.uk', 'puddy')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19012', 'Makayla', 'Stuart', NULL, NULL, '25 Alexander Road', 'Bristol', 'BS13 3BI', '07554315209', 'Makayla.Stuart@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19004', 'William', 'Alden', 'Just Bookings', 'E-Commerce', '40 Grange Road', 'Glasgow', 'G43 3CO', '07905452933', 'G.Alden@somedomain.co.uk', 'william')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19002', 'Gabriel', 'Burrow', NULL, NULL, '39 Kings Road', 'Glasgow', 'G5 6PN', '07298563217', 'Gabriel.Burrow@myemaildomain.com', 'burrow')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19032', 'Oliver', 'Luff', NULL, NULL, '43 Highfield Road', 'Glasgow', 'G20 2NM', '07379282398', 'G.Luff@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19001', 'Max', 'Dewhurst', NULL, NULL, '27 Main Road', 'Glasgow', 'G44 5SA', '07455721747', 'Max.Dewhurst@myemaildomain.com', 'max')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19029', 'Joshua', 'Frankland', NULL, NULL, '2 Main Road', 'Glasgow', 'G11 0NS', '07712774761', 'G.Frankland@somedomain.co.uk', 'frankland')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19036', 'Elijah', 'Trickett', NULL, NULL, '38 Main Road', 'Glasgow', 'G20 8JI', '07406811838', 'Elijah.Trickett@myemaildomain.com', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19041', 'Avery', 'Hrynko', NULL, NULL, '48 School Lane', 'Aberdeen', 'AB15 3IE', '07431887504', 'A.Hrynko@somedomain.co.uk', 'avery')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19017', 'Ariana', 'Stuart', NULL, NULL, '36 StreetName', 'Aberdeen', 'AB16 7MV', '07165882533', 'Ariana.Stuart@myemaildomain.com', 'stuart')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19010', 'Ariana', 'Maddern', 'The Management Firm', 'Consultncy', '37 Manor Road', 'Aboyne', 'AB34 4LY', '07521061659', 'A.Maddern@somedomain.co.uk', 'password')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19005', 'Savannah', 'Grieve', NULL, NULL, '7 Queens Road', 'Peterhead', 'AB42 1XM', '07773075498', 'Savannah.Grieve@myemaildomain.com', 'savannah')
INSERT INTO Owner (OwnerNo, FirstName, LastName, BusinessName, BusinessType, StreetAddress, City, Postcode, PhoneNo, Email, Password) VALUES ('CO19023', 'Olivia', 'Scott', NULL, NULL, '33 Mill Lane', 'Stonehaven', 'AB39 6TE', '07390155203', 'A.Scott@somedomain.co.uk', 'scott')



GO


/* Insert Data INTO Property */

-- DELETE FROM Property

INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190001', 'CO19010', 'House', 6, 650, '16 Holhead', 'Aberdeen', 'AB7 5SU', 'B0007', 'S29015')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190002', 'CO19004', 'Flat', 4, 450, '5 Novar Drive', 'Glasgow', 'G12 9AX', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190003', 'CO19002', 'House', 5, 600, '18 Dale Road', 'Glasgow', 'G12 4SA', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190004', 'CO19032', 'Flat', 3, 375, '2 Manor Road', 'Glasgow', 'G32 4QX', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190005', 'CO19001', 'Flat', 3, 350, '6 Lawrence Street', 'Glasgow', 'G11 9QX', 'B0007', 'S29015')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190006', 'CO19029', 'House', 3, 380, 'Muir Drive', 'Aberdeen', 'AB42 1DD', 'B0007', 'S29015')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190007', 'CO19015', 'Flat', 4, 400, '6 Argyll Street', 'London', 'NW2 5DE', 'B0008', 'S28013')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190008', 'CO19045', 'House', 4, 1150, '5 Queensway', 'East Ham', 'E6 3QC', 'B0005', 'S29009')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190009', 'CO19024', 'Flat', 1, 750, '12 The Avenue', 'Head District', 'EC1 1CU', 'B0005', 'S29019')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190010', 'CO19039', 'House', 4, 1350, '46 Highfield Road', 'Woodford', 'E18 0IF', 'B0005', 'S29020')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190011', 'CO19047', 'House', 6, 2000, '35 King Street', 'Leyton', 'E10 1TH', 'B0005', 'S29009')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190012', 'CO19044', 'House', 3, 1500, '40 George Street', 'East Finchley', 'N2 8MF', 'B0005', 'S29019')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190013', 'CO19034', 'Flat', 1, 900, '9 West Street', 'Fenchurch Street', 'EC3 6UI', 'B0005', 'S29020')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190014', 'CO19031', 'House', 6, 2150, '50 King Street', 'Olympic Park', 'E20 6AY', 'B0005', 'S29009')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190015', 'CO19019', 'Flat', 2, 720, '42 School Lane', 'Plaistow', 'E13 7ON', 'B0005', 'S29019')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190016', 'CO19052', 'Studio', 0, 700, '8 High Street', 'Olympic Park', 'E20 7UC', 'B0005', 'S29020')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190017', 'CO19049', 'House', 4, 1350, '28 Manor Road', 'Chingford', 'E4 8MU', 'B0005', 'S29009')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190018', 'CO19043', 'Flat', 2, 880, '3 Grange Road', 'Clapton', 'E5 0VH', 'B0005', 'S29019')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190019', 'CO19044', 'Flat', 1, 700, '5 Alexander Road', 'Homerton', 'E9 7CZ', 'B0005', 'S29020')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190020', 'CO19034', 'Flat', 1, 750, '19 St. John''s Road', 'Fleet Street', 'EC4 4PZ', 'B0005', 'S29009')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190021', 'CO19028', 'House', 4, 520, '46 The Crescent', 'Carmarthen', 'SA33 6TU', 'B0001', 'S29001')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190022', 'CO19048', 'Studio', 0, 220, '25 New Road', 'Lampeter', 'SA48 5CX', 'B0001', 'S29004')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190023', 'CO19007', 'House', 5, 680, '27 York Road', 'Swansea', 'SA4 3II', 'B0001', 'S29011')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190024', 'CO19051', 'House', 5, 820, '42 George Street', 'Lampeter', 'SA48 8ZF', 'B0001', 'S28012')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190025', 'CO19026', 'Studio', 0, 240, '24 Albert Road', 'Carmarthen', 'SA32 9ZB', 'B0002', 'S29002')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190026', 'CO19014', 'House', 6, 400, '6 Grange Road', 'Swansea', 'SA2 8YR', 'B0002', 'S28005')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190027', 'CO19018', 'Flat', 2, 310, '49 Alexander Road', 'Carmarthen', 'SA32 6YM', 'B0002', 'S29008')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190028', 'CO19035', 'Flat', 1, 460, '50 Broadway', 'Swansea', 'SA1 1FI', 'B0003', 'S28003')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190029', 'CO19040', 'House', 3, 550, '33 Victoria Street', 'Swansea', 'SA3 2OV', 'B0003', 'S29016')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190030', 'CO19025', 'House', 6, 800, '3 North Street', 'Swansea', 'SA2 6GA', 'B0003', 'S29017')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190031', 'CO19037', 'Flat', 2, 410, '39 York Road', 'Neath', 'SA11 9QI', 'B0003', 'S28018')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190032', 'CO19033', 'House', 4, 575, '24 Main Road', 'Swansea', 'SA2 8ME', 'B0002', 'S28005')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190033', 'CO19022', 'Flat', 2, 380, '39 Queensway', 'Swansea', 'SA1 2ZR', 'B0002', 'S29008')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190034', 'CO19038', 'House', 4, 550, '1 The Grove', 'Swansea', 'SA4 7CK', 'B0003', 'S28003')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190035', 'CO19008', 'Studio', 0, 450, '12 Queensway', 'Bristol', 'BS6 5RD', 'B0007', 'S29006')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190036', 'CO19021', 'House', 4, 1250, '27 North Street', 'Weston-Super-Mare', 'BS22 9EX', 'B0007', 'S29015')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190037', 'CO19006', 'Flat', 2, 760, '34 Alexander Road', 'Wedmore', 'BS28 1PQ', 'B0007', 'S29006')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190038', 'CO19042', 'Flat', 2, 800, '4 Springfield Road', 'Weston-Super-Mare', 'BS22 9ZH', 'B0007', 'S29015')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190039', 'CO19003', 'House', 6, 1600, '33 New Street', 'Bristol', 'BS16 3DD', 'B0007', 'S29006')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190040', 'CO19030', 'House', 4, 1350, '18 The Grove', 'Bristol', 'BS15 8KT', 'B0007', 'S29015')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190041', 'CO19032', 'House', 4, 1300, '43 York Road', 'Glasgow', 'G42 5MK', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190042', 'CO19001', 'House', 4, 1300, '23 Springfield Road', 'Glasgow', 'G1 2GK', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190043', 'CO19029', 'House', 5, 1500, '26 Park Avenue', 'Glasgow', 'G41 1MT', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190044', 'CO19036', 'House', 5, 1200, '12 New Road', 'Glasgow', 'G13 0XM', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190045', 'CO19029', 'House', 4, 1000, '28 Main Road', 'Glasgow', 'G22 1KH', 'B0006', 'S29007')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190046', 'CO19041', 'Flat', 2, 450, '32 Queen Street', 'Strathdon', 'AB36 6KV', 'B0009', 'S28014')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190047', 'CO19017', 'Flat', 2, 490, '16 Kings Road', 'Peterculter', 'AB14 8ZH', 'B0009', 'S28014')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190048', 'CO19010', 'House', 6, 1200, '29 St. John''s Road', 'Aberlour', 'AB38 5CQ', 'B0009', 'S28014')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190049', 'CO19005', 'House', 4, 900, '7 Park Lane', 'Aberdeen', 'AB21 3ZS', 'B0009', 'S28014')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190050', 'CO19023', 'Studio', 0, 250, '25 Queen Street', 'Alford', 'AB33 1PD', 'B0009', 'S28014')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190051', 'CO19041', 'House', 4, 850, '27 The Grove', 'Aboyne', 'AB34 3BJ', 'B0009', 'S28014')
INSERT INTO Property (PropertyNo, OwnerNo, Type, Rooms, Rent, StreetAddress, City, Postcode, BranchNo, ManagedBy) VALUES ('P190052', 'CO19017', 'House', 3, 750, '39 Alexander Road', 'Ballater', 'AB35 9FH', 'B0009', 'S28014')



GO


/* Insert Data INTO Client */

-- DELETE FROM Client

INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18021', 'Fred', 'Flintstone', '07978266774', 'fred@flintyrock.com', 'B0007', 'S29015', '17-Mar-2018', 'House', '1890')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18038', 'Wilma', 'Flintstone', '07987723432', 'wilma@flintyrock.com', 'B0006', 'S29007', '30-Apr-2018', 'Flat', '1290')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18001', 'Albert', 'Johnstone', '07326064185', 'albie@johnstone.com', 'B0007', 'S29015', '17-Mar-2018', 'Flat', '290')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18015', 'Clark', 'Kent', '07602133833', 'clark@supersite.com', 'B0002', 'S28005', '24-Apr-2018', 'Flat', '560')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18012', 'Joe', 'Bloggs', '07631585546', 'joe@paisley.com', 'B0002', 'S28005', '13-Mar-2018', 'House', '1250')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18026', 'Edward', 'Scissorhands', '07270629145', 'eddie@scix.com', 'B0002', 'S28005', '08-Jun-2018', 'House', '1410')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18008', 'Albert', 'Einstein', '07491976410', 'bert@nuclearintent.com', 'B0003', 'S28018', '04-Mar-2018', NULL, NULL)
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18007', 'Hannah', 'Williams', '07698784907', 'snorrie@iceland.com', 'B0001', 'S29004', '21-May-2018', NULL, NULL)
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18018', 'Juan', 'Quinn', '07833894601', 'ferdy@orage.com', 'B0007', 'S29015', '10-Feb-2018', 'Studio', '170')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18027', 'Kaylee', 'Smith', '07383285041', 'joes@largy.com', 'B0005', 'S29020', '12-Jun-2018', 'House', '1330')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18030', 'Kaylee', 'Procter', '07607745502', 'bill@gatesland.com', 'B0001', 'S29004', '11-Mar-2018', 'House', '1250')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18041', 'Lillian', 'Sanger', '07803458192', 'wayne@batty.com', 'B0009', 'S28014', '02-Mar-2018', 'House', '1850')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18004', 'William', 'Quinn', '07435495571', 'William.Quinn@myemaildomain.com', 'B0005', 'S29020', '26-Jun-2018', 'Studio', '280')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18028', 'Carter', 'Moxley', '07288852896', 'M.Moxley@somedomain.co.uk', 'B0009', 'S28014', '04-May-2018', 'House', '1570')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18006', 'Harper', 'Pratt', '07635024653', 'Harper.Pratt@myemaildomain.com', 'B0006', 'S29007', '06-Mar-2018', 'Flat', '520')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18017', 'Robert', 'Wilson', '07681502425', 'W.Wilson@somedomain.co.uk', 'B0005', 'S29019', '13-Feb-2018', 'Flat', '930')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18036', 'Adrian', 'Moxley', '07342671056', 'Adrian.Moxley@myemaildomain.com', 'B0006', 'S29007', '07-Feb-2018', 'Flat', '1050')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR18033', 'Juan', 'Tuch', '07931924726', 'T.Tuch@somedomain.co.uk', 'B0009', 'S28014', '07-Feb-2018', 'House', '1350')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19010', 'Landon', 'Pendry', '07861206166', 'Landon.Pendry@myemaildomain.com', 'B0007', 'S29006', '04-Jun-2019', 'House', '1090')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19024', 'Jaden', 'Wilson', '07729022870', 'W.Wilson@somedomain.co.uk', 'B0001', 'S29004', '15-Feb-2019', NULL, NULL)
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19025', 'Jayden', 'Harding', '07158525704', 'Jayden.Harding@myemaildomain.com', 'B0009', 'S28014', '30-May-2019', NULL, NULL)
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19002', 'Adam', 'Trevena', '07487737570', 'T.Trevena@somedomain.co.uk', 'B0001', 'S28012', '03-May-2019', 'Studio', '320')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19034', 'Madelyn', 'Pendry', '07101911915', 'Madelyn.Pendry@myemaildomain.com', 'B0008', 'S28013', '18-Apr-2019', 'House', '1690')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19005', 'Austin', 'Cooley', '07163316043', 'C.Cooley@somedomain.co.uk', 'B0003', 'S29017', '23-Jun-2019', 'House', '1450')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19011', 'Gianna', 'Tyson', '07251759226', 'Gianna.Tyson@myemaildomain.com', 'B0003', 'S29016', '21-May-2019', 'House', '1570')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19022', 'Jackson', 'Maddern', '07685331606', 'M.Maddern@somedomain.co.uk', 'B0002', 'S29002', '06-Mar-2019', 'Studio', '630')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19020', 'Jonathan', 'May', '07601086197', 'Jonathan.May@myemaildomain.com', 'B0008', 'S29010', '27-Jun-2019', 'House', '620')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19013', 'Avery', 'Jermyn', '07841484099', 'J.Jermyn@somedomain.co.uk', 'B0009', 'S28014', '22-Feb-2019', 'Flat', '350')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19014', 'Harper', 'Tuch', '07456626495', 'Harper.Tuch@myemaildomain.com', 'B0008', 'S28013', '20-Mar-2019', 'Flat', '400')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19019', 'Zoe', 'Abbs', '07184671570', 'A.Abbs@somedomain.co.uk', 'B0007', 'S29015', '24-Mar-2019', 'Flat', '390')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19032', 'Jonathan', 'Thackeray', '07847555008', 'Jonathan.Thackeray@myemaildomain.com', 'B0006', 'S29007', '05-Feb-2019', 'House', '1720')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19031', 'Kevin', 'Tuch', '07327606772', 'T.Tuch@somedomain.co.uk', 'B0005', 'S29020', '23-Feb-2019', 'House', '720')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19039', 'Serenity', 'Brown', '07170545156', 'Serenity.Brown@myemaildomain.com', 'B0006', 'S29007', '25-Jun-2019', NULL, NULL)
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19003', 'Max', 'Burt', '07282368032', 'B.Burt@somedomain.co.uk', 'B0001', 'S29001', '02-Mar-2019', NULL, NULL)
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19037', 'Morgan', 'Quinn', '07643069576', 'Morgan.Quinn@myemaildomain.com', 'B0005', 'S29009', '02-Mar-2019', 'Studio', '280')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19035', 'Brianna', 'Ellis', '07603922683', 'E.Ellis@somedomain.co.uk', 'B0002', 'S28005', '05-May-2019', 'House', '970')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19016', 'Henry', 'Frankland', '07488093249', 'Henry.Frankland@myemaildomain.com', 'B0003', 'S28018', '04-May-2019', 'House', '530')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19009', 'Alexa', 'Johnston', '07453156681', 'J.Johnston@somedomain.co.uk', 'B0003', 'S28003', '11-Mar-2019', 'House', '1040')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19029', 'Aubrey', 'Cooley', '07878733713', 'Aubrey.Cooley@myemaildomain.com', 'B0001', 'S29004', '29-Apr-2019', 'Studio', '620')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19023', 'Nathan', 'Cooper', '07383938660', 'C.Cooper@somedomain.co.uk', 'B0008', 'S28013', '25-Jun-2019', 'House', '1430')
INSERT INTO Client (ClientNo, FirstName, LastName, PhoneNo, Email, BranchNo, RegisteredBy, RegistrationDate, PropertyTypePref, MaxRent) VALUES ('CR19040', 'Makayla', 'Thackeray', '07273399892', 'Makayla.Thackeray@myemaildomain.com', 'B0008', 'S29010', '15-Jun-2019', 'Flat', '540')



GO


/* Insert Data INTO Viewing */

-- DELETE FROM Viewing

INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190021', 'CR19024', NULL, '09-Jul-2019 17:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190022', 'CR18030', NULL, '09-Mar-2019 17:00', 'Tidy but too small', 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190023', 'CR19003', NULL, '07-Aug-2019 13:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190024', 'CR18007', NULL, '16-Jun-2019 17:00', 'Kitchen too small.', 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190025', 'CR18026', NULL, '31-May-2019 15:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190026', 'CR18015', NULL, '26-Aug-2019 17:00', 'Not bad at all.', 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190027', 'CR18012', NULL, '11-Apr-2019 16:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190033', 'CR19022', NULL, '07-Sep-2019 16:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190029', 'CR19016', NULL, '09-Mar-2019 15:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190030', 'CR18008', NULL, '17-May-2019 14:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190031', 'CR19011', NULL, '13-Aug-2019 14:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190002', 'CR19032', NULL, '18-May-2019 17:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190035', 'CR19010', NULL, '10-May-2019 15:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190007', 'CR19023', NULL, '26-Jul-2019 14:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190007', 'CR19040', NULL, '29-May-2019 15:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190049', 'CR18028', NULL, '29-Jul-2019 15:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190051', 'CR18033', NULL, '31-Mar-2019 14:00', NULL, 0)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190034', 'CR19025', NULL, '04-Nov-2019 12:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190038', 'CR18015', NULL, '03-Oct-2019 14:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190038', 'CR19029', NULL, '07-Nov-2019 12:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190019', 'CR18015', NULL, '07-Dec-2019 14:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190048', 'CR19022', NULL, '27-Oct-2019 17:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190044', 'CR18027', NULL, '29-Dec-2019 15:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190018', 'CR19022', NULL, '25-Oct-2019 16:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190020', 'CR19037', NULL, '13-Dec-2019 12:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190044', 'CR18004', NULL, '29-Dec-2019 14:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190001', 'CR19023', NULL, '03-Oct-2019 13:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190027', 'CR18033', NULL, '26-Nov-2019 13:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190020', 'CR19023', NULL, '08-Oct-2019 15:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190023', 'CR19014', NULL, '02-Oct-2019 13:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190017', 'CR19020', NULL, '27-Dec-2019 16:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190024', 'CR18007', NULL, '02-Nov-2019 16:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190052', 'CR19032', NULL, '22-Dec-2019 13:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190001', 'CR18030', NULL, '04-Dec-2019 17:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190020', 'CR19025', NULL, '02-Oct-2019 17:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190050', 'CR19011', NULL, '28-Oct-2019 14:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190021', 'CR19014', NULL, '28-Nov-2019 15:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190019', 'CR18015', NULL, '19-Oct-2019 12:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190006', 'CR19003', NULL, '31-Oct-2019 14:00', NULL, NULL)
INSERT INTO Viewing (PropertyNo, ClientNo, StaffNo, ViewingDateTime, Comment, WishToRent) VALUES ('P190051', 'CR19016', NULL, '16-Dec-2019 13:00', NULL, NULL)



GO


/* Insert Data INTO Lease */

-- DELETE FROM Lease

INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18001', 'CR18017', 'P190016', '13-Mar-2018', '13-Jan-2019', 690, 'Direct Debit 09-01-28 13745521', 1035)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18002', 'CR18038', 'P190041', '30-May-2018', '30-Mar-2019', 1290, 'Direct Debit 56-00-03 13354647', 1935)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18003', 'CR18036', 'P190042', '07-Mar-2018', '07-Jan-2019', 1290, 'Direct Debit 56-00-03 23354647', 1935)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18004', 'CR18006', 'P190002', '06-Apr-2018', '06-Feb-2019', 440, 'Direct Debit 30-80-88 14457846', 660)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18005', 'CR18018', 'P190037', '10-Mar-2018', '10-Dec-2018', 750, 'Direct Debit 56-57-77 88012345', 1125)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18006', 'CR18021', 'P190040', '17-Apr-2018', '17-Jan-2019', 1340, 'Direct Debit 56-57-77 88012346', 2010)

INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19007', 'CR19002', 'P190022', '03-Jun-2019', '03-Feb-2020', 220, 'Direct Debit 40-47-84 70872490', 330)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19008', 'CR19035', 'P190026', '05-Jun-2019', '05-Feb-2020', 400, 'Direct Debit 40-47-84 70872491', 600)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19009', 'CR19009', 'P190030', '11-Apr-2019', '11-Nov-2019', 800, 'Direct Debit 20-51-32 13537846', 1200)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19010', 'CR19005', 'P190031', '23-Jul-2019', '23-Mar-2020', 410, 'Direct Debit 20-51-32 23537846', 615)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19011', 'CR19031', 'P190011', '23-Mar-2019', '23-Sep-2019', 2000, 'Direct Debit 09-01-28 03745521', 3000)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18012', 'CR18017', 'P190016', '13-Jan-2019', '13-Sep-2019', 700, 'Direct Debit 09-01-28 13745521', 1050)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18013', 'CR18038', 'P190041', '30-Mar-2019', '30-Sep-2019', 1300, 'Direct Debit 56-00-03 13354647', 1950)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18014', 'CR18036', 'P190042', '07-Jan-2019', '07-Aug-2019', 1300, 'Direct Debit 56-00-03 23354647', 1950)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19015', 'CR19039', 'P190045', '25-Jul-2019', '25-Feb-2020', 1000, 'Direct Debit 30-80-87 25337846', 1500)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18016', 'CR18006', 'P190002', '06-Feb-2019', '06-Aug-2019', 450, 'Direct Debit 30-80-88 14457846', 675)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19017', 'CR19019', 'P190035', '24-Apr-2019', '24-Nov-2019', 450, 'Direct Debit 30-80-88 24457846', 675)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18018', 'CR18018', 'P190037', '10-Dec-2018', '10-Aug-2019', 760, 'Direct Debit 56-57-77 88012345', 1140)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18019', 'CR18021', 'P190040', '17-Jan-2019', '17-Aug-2019', 1350, 'Direct Debit 56-57-77 88012346', 2025)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18020', 'CR18001', 'P190005', '17-Jan-2019', '17-Sep-2019', 350, 'Direct Debit 56-57-77 88012347', 525)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19021', 'CR19034', 'P190007', '18-May-2019', '18-Nov-2019', 400, 'Direct Debit 56-57-77 88012348', 600)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L19022', 'CR19013', 'P190046', '22-Mar-2019', '22-Sep-2019', 450, 'Direct Debit 56-57-77 88012349', 675)
INSERT INTO Lease (LeaseNo, ClientNo, PropertyNo, RentStart, RentFinish, MonthlyRent, PaymentMethod, DepositPaid) VALUES ('L18023', 'CR18041', 'P190047', '02-Jan-2019', '02-Aug-2019', 490, 'Direct Debit 56-57-77 88012350', 735)


GO