INSERT INTO employees(first_name, last_name, gender, birthdate, age, department_id)
	VALUES ('Marlo', 'O\'Malley', 'M', '1958-09-21', TIMESTAMPDIFF(YEAR, '1958-09-21', NOW()), 1),
			 ('Niki', 'Stanaghan', 'F', '1969-11-26', TIMESTAMPDIFF(YEAR, '1969-11-26', NOW()), 4),
			 ('Ayrton', 'Senna', 'M', '1960-03-21', TIMESTAMPDIFF(YEAR, '1960-03-21', NOW()), 9),
			 ('Ronnie', 'Peterson', 'M', '1944-02-14', TIMESTAMPDIFF(YEAR, '1944-02-14', NOW()), 9),
			 ('Giovanna', 'Amati', 'F', '1959-07-20', TIMESTAMPDIFF(YEAR, '1959-07-20', NOW()), 5);

INSERT INTO reports(category_id, status_id, open_date, close_date, description, user_id, employee_id)
	VALUES (1, 1, '2017-04-13', NULL, 'Stuck Road on Str.133', 6, 2),
			 (6, 3, '2015-09-05', '2015-12-06', 'Charity trail running', 3, 5),
			 (14, 2, '2015-09-07', NULL, 'Falling bricks on Str.58', 5, 2),
			 (4, 3, '2017-07-03', '2017-07-06', 'Cut off streetlight on Str.11', 1, 1);