INSERT INTO demohires(firstName, lastName, role, startDate, practice, recruitmentInitials, roleStatus)
VALUES('Kevin', 'Hall', 'Associate Consultant', CURDATE(), 'MSP', 'AG', 'Filled'),
('Amy', 'Byrne', 'Associate Consultant', CURDATE(), 'ERP', 'BM', 'Vacant'),
('Paul', 'Short', 'Associate Consultant', CURDATE(), 'ERP', 'AG', 'Filled'),
('John', 'Smith', 'Associate Consultant', CURDATE(), 'MSP', 'RA', 'Vacant'),
('Paul', 'Talyor', 'Associate Consultant', CURDATE(), 'MSP', 'SW', 'Filled'),
('John', 'Talyor', 'Associate Consultant', CURDATE(), 'ERP', 'AG', 'Vacant'),
('Tony', 'Smith', 'Associate Consultant', CURDATE(), 'MSP', 'SW', 'Filled'),
('Dean', 'Byrne', 'Associate Consultant', CURDATE(), 'BAS', 'SW', 'Filled'),
('Dean', 'Jones', 'Associate Consultant', CURDATE(), 'MSP', 'AG', 'Filled'),
('Amy', 'Byrne', 'Associate Consultant', CURDATE(), 'BAS', 'RA', 'Vacant'),
('Tony', 'Smith', 'Associate Consultant', CURDATE(), 'Cloud', 'BM', 'Filled'),
('Sarah', 'Harris', 'Associate Consultant', CURDATE(), 'BAS', 'AG', 'Filled'),
('Mark', 'Byrne', 'Associate Consultant', CURDATE(), 'License Management', 'AG', 'Vacant'),
('Tom', 'Harris', 'Associate Consultant', CURDATE(), 'MSP', 'RA', 'Filled'),
('Harry', 'Smith', 'Associate Consultant', CURDATE(), 'ERP', 'AG', 'Vacant'),
('Frank', 'Byrne', 'Associate Consultant', CURDATE(), 'Business Intelligence', 'AG', 'Filled'),
('Paul', 'Harris', 'Associate Consultant', CURDATE(), 'MSP', 'SW', 'Filled'),
('Simon', 'Smith', 'Associate Consultant', CURDATE(), 'MSP', 'AG', 'Filled'),
('Mary', 'Byrne', 'Associate Consultant', CURDATE(), 'Business Intelligence', 'AG', 'Vacant'),
('Damien', 'Jones', 'Associate Consultant', CURDATE(), 'MSP', 'SW', 'Filled'),
('Mark', 'Davidson', 'Associate Consultant', CURDATE(), 'ERP', 'AG', 'Filled'),
('Damien', 'Davidson', 'Associate Consultant', CURDATE(), 'BAS', 'BM', 'Vacant'),
('Mark', 'Jones', 'Associate Consultant', CURDATE(), 'MSP', 'BM', 'Filled');