Wednesday, February 19, 2020

Current Month Checker With PHP and MYSQLi

I wrote this simple code using PHP and MySQL to check if the given month the current month and display then personnel that has a birthday on the month of February in this example. The code is very easy to understand and use for anyone. I hope you will find my work useful.

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod City, Negros Occidental I also accepting computer repair, web development using WordPress, Computer Networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com
My programming website is http://www.jakerpomperada.blogspot.com

I am also a book author you can purchase my books on computer programming and information technology in the following links below.

https://www.mindshaperspublishing.com/
https://www.unlimitedbooksph.com/


Sample Program Output


Program Listing

index.php

<?php 
$month = date('m');


$con = mysqli_connect("localhost","root","","employee");

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  exit();
}

$sql = "SELECT lastname,firstname,birth_month,birthday_day FROM emp_records WHERE birth_month ='FEBRUARY' ORDER BY lastname ASC ";
$sql2 = "SELECT COUNT(birth_month) FROM emp_records WHERE birth_month ='FEBRUARY'"; 

echo "Month of February";
echo "<br><br>";
if($month == 2){
if ($result = mysqli_query($con, $sql)) {
  // Fetch one and one row
while ($row = mysqli_fetch_row($result)) {
printf ("%s\t %s \t\t\t\t %s \t%s<br><br>", $row[0], $row[1],$row[2], $row[3]);
}
  mysqli_free_result($result);
}
} else {
   echo "<br /> The month is probably not February.";
}

if($month == 2){
if ($result = mysqli_query($con, $sql2)) {
  // Fetch one and one row
while ($row = mysqli_fetch_row($result)) {
printf ("Total Number of Records %s.", $row[0]);
}
  mysqli_free_result($result);
}
} else {
   echo "<br /> The month is probably not February.";
}
mysqli_close($con);
?>


employee.sql

/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.5.5-10.0.17-MariaDB : Database - employee
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`employee` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `employee`;

/*Table structure for table `emp_records` */

CREATE TABLE `emp_records` (
  `emp_id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `personnel` varchar(100) NOT NULL,
  `years_service` int(2) NOT NULL,
  `loyalty_awards` int(2) NOT NULL,
  `turn_over` varchar(100) NOT NULL,
  `education` varchar(100) NOT NULL,
  `birth_month` varchar(100) NOT NULL,
  `birthday_day` int(2) NOT NULL,
  `leaves` int(2) NOT NULL,
  PRIMARY KEY (`emp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=latin1;

/*Data for the table `emp_records` */

insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (1,'LUCAS\r\n','TURNER\r\n','MALE\r\n','NON-TEACHING\r\n',29,5,'TRANSFERRED\r\n','BACHELORS\r\n','JANUARY\r\n',2,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (2,'NATHALIE\r\n','ROBERTSON\r\n','MALE\r\n','TECHING\r\n',22,10,'RETIRED\r\n','MASTERS\r\n','MAY\r\n',4,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (3,'OWEN\r\n','MAY\r\n','FEMALE\r\n','TEACHING\r\n',25,15,'RESIGNED\r\n','DOCTORATE\r\n','MARCH\r\n',23,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (4,'LUCAS\r\n','NEWMAN\r\n','MALE\r\n','NON-TEACHING\r\n',23,20,'RETIRED\r\n','BACHELORS\r\n','DECEMBER\r\n',12,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (5,'TIM\r\n','JAMES\r\n','MALE\r\n','NON-TEACHING\r\n',17,25,'RESIGNED\r\n','BACHELORS\r\n','AUGUST\r\n',18,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (6,'NEIL\r\n','MANNING\r\n','MALE\r\n','TEACHING\r\n',23,30,'TRANSFERRED\r\n','BACHELORS\r\n','JULY\r\n',3,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (7,'SEAN\r\n','BROWN\r\n','MALE\r\n','TEACHING\r\n',28,35,'TRANSFERRED\r\n','DOCTORATE\r\n','SEPTEMBER\r\n',16,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (8,'ERIC\r\n','TERRY\r\n','FEMALE\r\n','NON-TEACHING\r\n',6,40,'RETIRED\r\n','MASTERS\r\n','NOVEMBER\r\n',13,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (9,'AVA\r\n','ALSOP\r\n','MALE\r\n','TEACHING\r\n',18,45,'RESIGNED\r\n','BACHELORS\r\n','JUNE\r\n',25,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (10,'THOMAS\r\n','ABRAHAM\r\n','MALE\r\n','TEACHING\r\n',13,5,'RETIRED\r\n','DOCTORATE\r\n','APRIL\r\n',21,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (11,'JACOB\r\n','CARR\r\n','MALE\r\n','NON-TEACHING\r\n',5,10,'RESIGNED\r\n','MASTERS\r\n','OCTOBER\r\n',17,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (12,'ALAN\r\n','RUTHERFORD\r\n','MALE\r\n','TEACHING\r\n',35,15,'TRANSFERRED\r\n','MASTERS\r\n','FEBRUARY\r\n',15,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (13,'CHLOE\r\n','WELCH\r\n','FEMALE\r\n','TEACHING\r\n',33,20,'RETIRED','DOCTORATE\r\n','AUGUST\r\n',8,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (14,'DONNA\r\n','HUGHES\r\n','FEMALE\r\n','NON-TEACHING\r\n',19,25,'RESIGNED\r\n','BACHELORS\r\n','SEPTEMBER\r\n',20,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (15,'LEAH\r\n','HODGES\r\n','FEMALE\r\n','NON-TEACHING\r\n',30,30,'RETIRED\r\n','BACHELORS\r\n','MARCH\r\n',29,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (16,'ANDREA\r\n','VANCE\r\n','FEMALE\r\n','NON-TEACHING\r\n',17,35,'RETIRED\r\n','BACHELORS\r\n','JUNE\r\n',2,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (17,'DAVID\r\n','ROBERTS\r\n','MALE\r\n','TEACHING\r\n',12,40,'TRANSFERRED\r\n','DOCTORATE\r\n','JULY\r\n',13,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (18,'PIPPA\r\n','ROBERTSON\r\n','FEMALE\r\n','TEACHING\r\n',41,45,'TRANSFERRED\r\n','MASTERS\r\n','MAY\r\n',30,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (19,'MARY\r\n','BAILEY\r\n','FEMALE\r\n','NON-TEACHING\r\n',13,15,'RETIRED\r\n','BACHELORS\r\n','DECEMBER\r\n',13,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (20,'LEONARD\r\n','SKINNER\r\n','MALE\r\n','TEACHING\r\n',14,20,'RESIGNED\r\n','DOCTORATE\r\n','OCTOBER\r\n',15,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (21,'EMMA\r\n','PATERSON\r\n','FEMALE\r\n','NON-TEACHING\r\n',39,25,'RETIRED\r\n','MASTERS\r\n','JANUARY\r\n',1,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (22,'PETER\r\n','NORTH\r\n','MALE\r\n','NON-TEACHING\r\n',30,30,'RESIGNED\r\n','BACHELORS\r\n','NOVEMBER\r\n',14,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (23,'LILY\r\n','MILLS\r\n','FEMALE\r\n','NON-TEACHING\r\n',39,35,'TRANSFERRED\r\n','BACHELORS\r\n','APRIL\r\n',3,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (25,'STEPHEN\r\n','KERR\r\n','MALE\r\n','TEACHING\r\n',23,40,'TRANSFERRED\r\n','BACHELORS\r\n','FEBRUARY\r\n',14,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (26,'CHRISTIAN\r\n','GRANT\r\n','MALE\r\n','TEACHING\r\n',41,45,'RETIRED\r\n','DOCTORATE\r\n','MARCH\r\n',30,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (27,'JOHN\r\n','WELCH\r\n','MALE\r\n\r\n','TEACHING\r\n',5,5,'RESIGNED\r\n','MASTERS\r\n','SEPTEMBER\r\n',29,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (28,'CHRISTINE\r\n','HILL\r\n','MALE\r\n','NON-TEACHING\r\n',10,10,'RETIRED\r\n','BACHELORS\r\n','AUGUST\r\n',18,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (29,'WARREN\r\n','HILL\r\n','MALE\r\n','NON-TEACHING\r\n',25,15,'RESIGNED\r\n','DOCTORATE\r\n','JANUARY\r\n',1,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (30,'STEPHEN\r\n','MANNING\r\n','MALE\r\n','TEACHING\r\n',45,20,'TRANSFERRED\r\n','MASTERS\r\n','MAY\r\n',30,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (31,'KATHERINE\r\n','WARR\r\n','FEMALE\r\n','TEACHING\r\n',40,25,'RETIRED\r\n','MASTERS\r\n','JULY\r\n',23,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (32,'PETER\r\n','PARR\r\n','MALE\r\n','TEACHING\r\n',22,5,'RESIGNED\r\n','DOCTORATE\r\n','DECEMBER\r\n',25,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (33,'FRANK\r\n','RANDALL\r\n','MALE\r\n','NON-TEACHING\r\n',1,10,'RETIRED\r\n','BACHELORS\r\n','FEBRUARY\r\n',17,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (34,'STEVEN\r\n','RANDALL\r\n','MALE\r\n','TEACHING\r\n',33,15,'RETIRED\r\n','BACHELORS\r\n','OCTOBER\r\n',15,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (35,'SEAN\r\n','ARNOLD\r\n','MALE\r\n','NON-TEACHING\r\n',15,20,'TRANSFERRED\r\n','BACHELORS\r\n','JUNE\r\n',1,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (36,'JOSEPH\r\n','CHAPMAN\r\n','MALE\r\n','NON-TEACHING\r\n',27,25,'TRANSFERRED\r\n','DOCTORATE\r\n','JUNE\r\n',3,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (37,'ALISON\r\n','FERGUSON\r\n','FEMALE\r\n','TEACHING\r\n',32,30,'RETIRED\r\n','MASTERS\r\n','APRIL\r\n',1,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (38,'AUSTIN\r\n','FRASER\r\n','MALE\r\n','TEACHING\r\n',8,35,'RESIGNED\r\n','BACHELORS\r\n','DECEMBER\r\n',30,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (39,'TREVOR\r\n','VANCE\r\n','MALE\r\n','NON-TEACHING\r\n',34,40,'RETIRED\r\n','DOCTORATE\r\n','AUGUST\r\n',28,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (40,'OWEN\r\n','DUNCAN\r\n','MALE\r\n','NON-TEACHING\r\n',38,45,'RESIGNED\r\n','DOCTORATE\r\n','JULY\r\n',23,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (41,'VIRGINIA\r\n','CORNISH\r\n','FEMALE\r\n','TEACHING\r\n',33,5,'TRANSFERRED\r\n','DOCTORATE\r\n','SEPTEMBER',10,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (42,'KEVIN\r\n','TURNER\r\n','MALE\r\n','TEACHING\r\n',12,10,'TRANSFERRED\r\n','BACHELORS\r\n','NOVEMBER\r\n',2,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (43,'EDWARD\r\n','HODGES\r\n','MALE\r\n','TEACHING\r\n',28,15,'RETIRED\r\n','BACHELORS\r\n','JUNE',6,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (44,'JASMINE\r\n','WALKER\r\n','FEMALE\r\n','NON-TEACHING\r\n',4,20,'RESIGNED\r\n','DOCTORATE\r\n','APRIL\r\n',3,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (45,'FELICITY\r\n','CAMERON\r\n','FEMALE\r\n','TEACHING\r\n',19,25,'RETIRED\r\n','MASTERS\r\n','OCTOBER\r\n',14,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (46,'ANTHONY\r\n','ANDERSON\r\n','MALE\r\n','NON-TEACHING\r\n',7,30,'RESIGNED\r\n','BACHELORS\r\n','FEBRUARY\r\n',13,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (47,'ADAM\r\n','SANDERSON\r\n','MALE\r\n','TEACHING \r\n',43,35,'TRANSFERRED\r\n','DOCTORATE\r\n','AUGUST\r\n',15,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (48,'MATT\r\n','ANDERSON\r\n','MALE\r\n','NON-TEACHING\r\n',41,40,'RETIRED\r\n','MASTERS\r\n','SEPTEMBER\r\n',18,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (49,'MICHELLE\r\n','METCALFE\r\n','FEMALE\r\n','TEACHING\r\n',18,5,'RESIGNED\r\n','BACHELORS\r\n','MARCH\r\n',23,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (50,'DIANA\r\n','MITCHELL\r\n','FEMALE\r\n','NON-TEACHING\r\n',19,10,'RETIRED\r\n','BACHELORS\r\n','JUNE',28,27);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (51,'NATHALIE\r\n','SLATER\r\n','FEMALE\r\n','TEACHING\r\n',36,15,'RETIRED\r\n','BACHELORS\r\n','JULY\r\n',12,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (52,'JENNIFER\r\n','COLEMAN\r\n','FEMALE\r\n','NON-TEACHING\r\n',6,20,'TRANSFERRED\r\n','DOCTORATE\r\n','MAY\r\n',16,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (53,'MAX\r\n','WALKER\r\n','MALE\r\n','TEACHING \r\n',18,25,'TRANSFERRED\r\n','MASTERS\r\n','DECEMBER\r\n',19,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (54,'JOSHUA\r\n','PULLMAN\r\n','MALE\r\n','TEACHING \r\n',13,30,'RETIRED\r\n','BACHELORS\r\n','OCTOBER\r\n',30,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (55,'RACHEL\r\n','SKINNER\r\n','FEMALE\r\n','NON-TEACHING\r\n',1,35,'RESIGNED\r\n','DOCTORATE\r\n','JANUARY\r\n',23,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (56,'JASON\r\n','MILLS\r\n','MALE\r\n','TEACHING\r\n',28,40,'RETIRED\r\n','MASTERS\r\n','NOVEMBER\r\n',27,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (57,'JONATHAN\r\n','ROBERTSON\r\n','MALE\r\n','NON-TEACHING\r\n',20,45,'RESIGNED\r\n','MASTERS\r\n','APRIL\r\n',11,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (58,'BLAKE\r\n','FERGUSON\r\n','MALE\r\n','NON-TEACHING\r\n',25,5,'TRANSFERRED\r\n\r\n','DOCTORATE\r\n\r\n','FEBRUARY\r\n',12,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (59,'NATHAN\r\n','REES\r\n','MALE\r\n','TEACHING\r\n',14,10,'TRANSFERRED\r\n','BACHELORS\r\n','MARCH\r\n',18,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (60,'EMILY\r\n','ROSS\r\n','FEMALE\r\n','NON-TEACHING\r\n',42,15,'RETIRED\r\n','BACHELORS\r\n','SEPTEMBER\r\n',23,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (61,'JOE\r\n','HARRIS\r\n','FEMALE\r\n','TEACHING\r\n',17,20,'RESIGNED\r\n','BACHELORS\r\n','AUGUST\r\n',19,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (62,'BRIAN\r\n','OLIVER\r\n','MALE\r\n','NON-TEACHING\r\n',18,25,'RETIRED\r\n','DOCTORATE\r\n','JANUARY\r\n',24,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (63,'SARAH\r\n','GREENE\r\n','FEMALE\r\n','TEACHING\r\n',22,30,'RESIGNED\r\n','BACHELORS\r\n','MAY\r\n',28,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (64,'LAUREN\r\n','NEWMAN\r\n','FEMALE\r\n','NON-TEACHING\r\n',8,35,'TRANSFERRED\r\n','DOCTORATE\r\n','JULY',25,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (65,'ROSE\r\n','CLARKSON\r\n','FEMALE\r\n','TEACHING\r\n',13,40,'RETIRED\r\n','MASTERS\r\n','DECEMBER\r\n',16,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (66,'DIANA\r\n','CARR\r\n','FEMALE\r\n','NON-TEACHING\r\n',37,5,'RESIGNED\r\n','BACHELORS\r\n','FEBRUARY\r\n',13,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (67,'DAVID\r\n','GILL\r\n','MALE\r\n','TEACHING\r\n',44,10,'RETIRED\r\n','BACHELORS\r\n','OCTOBER\r\n',17,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (68,'SEAN\r\n','OGDEN\r\n','MALE\r\n','NON-TEACHING\r\n',42,15,'RETIRED\r\n','BACHELORS\r\n','SEPTEMBER\r\n',16,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (69,'JASON\r\n','JASON\r\n','\r\nFORSYTH\r\n','\r\nMALE\r\n',43,20,'NON-TEACHING\r\n','TRANSFERRED\r\n','MARCH\r\n',1,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (70,'BERNADETTE\r\n','TURKER\r\n','FEMALE\r\n','NON TEACHING\r\n',25,25,'TRANSFERRED\r\n','MASTERS\r\n','JUNE\r\n',6,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (71,'TREVOR\r\n','CHAPMAN\r\n','MALE\r\n','TEACHING\r\n',18,30,'RETIRED\r\n','BACHELORS\r\n','JULY\r\n',9,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (72,'CHRISTIAN\r\n','MCLEAN\r\n','MALE\r\n','NON-TEACHING\r\n',13,35,'RESIGNED\r\n','DOCTORATE\r\n','MAY\r\n',2,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (73,'STEPHANIE\r\n','CAMERON\r\n','FEMALE\r\n','TEACHING\r\n',45,40,'RETIRED\r\n','MASTERS\r\n','DECEMBER\r\n',12,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (74,'STEPHEN\r\n','WALKER\r\n','MALE\r\n','TEACHING\r\n',30,45,'RETIRED\r\n','MASTERS\r\n','OCTOBER\r\n',15,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (75,'COLIN\r\n','WELCH\r\n','FEMALE\r\n','TEACHING\r\n',14,5,'TRANSFERRED\r\n','DOCTORATE\r\n','JANUARY\r\n',12,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (76,'MARIA\r\n','BOND\r\n','FEMALE\r\n','NON-TEACHING\r\n',21,10,'TRANSFERRED\r\n','BACHELORS\r\n','NOVEMBER\r\n',15,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (77,'ADAM\r\n','JONES\r\n','MALE\r\n','TEACHING\r\n',36,15,'RETIRED\r\n','BACHELORS\r\n','APRIL\r\n',16,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (78,'PIERS\r\n','TAYLOR\r\n','MALE\r\n','NON-TEACHING\r\n',3,20,'RESIGNED\r\n','BACHELORS\r\n','FEBRUARY\r\n',27,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (79,'IAN\r\n','JONES\r\n','MALE\r\n','TEACHING\r\n',7,25,'RETIRED\r\n','DOCTORATE\r\n','MARCH\r\n',23,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (80,'ALEXANDER\r\n','YOUNG\r\n','MALE\r\n','NON-TEACHING\r\n',9,30,'RESIGNED\r\n','MASTERS\r\n','SEPTEMBER\r\n',2,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (81,'JULIAN\r\n','MCLEAN\r\n','FEMALE\r\n','NON-TEACHING\r\n',12,35,'TRANSFERRED\r\n','BACHELORS\r\n','AUGUST\r\n',3,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (82,'AUDREY\r\n','DICKENS\r\n','FEMALE\r\n','TEACHING\r\n',11,40,'TRANSFERRED\r\n','DOCTORATE\r\n','JANUARY\r\n',12,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (83,'OLIVIA\r\n','FRASER\r\n','FEMALE\r\n','NON-TEACHING\r\n',18,40,'RETIRED\r\n','DOCTORATE\r\n','MAY\r\n',19,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (84,'EMILY\r\n','HUDSON\r\n','FEMALE\r\n','TEACHING\r\n',28,45,'RESIGNED\r\n','DOCTORATE\r\n','JULY\r\n',20,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (85,'NATHAN\r\n','RUTHERFORD\r\n','MALE\r\n\r\n','NON-TEACHING\r\n',38,5,'RETIRED\r\n','BACHELORS\r\n','DECEMBER\r\n',24,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (86,'PHIL\r\n','SLATER\r\n','MALE\r\n','NON-TEACHING\r\n',22,10,'RESIGNED\r\n','BACHELORS\r\n','FEBRUARY\r\n',26,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (87,'JULIAN\r\n','SLATER\r\n','MALE\r\n','TEACHING\r\n',11,15,'TRANSFERRED\r\n','MASTERS\r\n','OCTOBER\r\n',28,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (88,'LUKE\r\n','ELISON\r\n','MALE\r\n','NON-TEACHING\r\n',30,20,'RETIRED\r\n','BACHELORS\r\n','NOVEMBER\r\n',12,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (89,'KEITH\r\n','HUNTER\r\n','MALE\r\n','TEACHING\r\n',10,25,'RESIGNED\r\n','BACHELORS\r\n','JUNE\r\n',14,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (90,'DIANE\r\n','STEWART\r\n','FEMALE\r\n','NON-TEACHING\r\n',11,5,'RETIRED\r\n','BACHELORS\r\n','APRIL\r\n',23,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (91,'OLIVIA\r\n','ARNOLD\r\n','FEMALE\r\n','TEACHING\r\n',14,10,'RETIRED\r\n','DOCTORATE\r\n','DECEMBER\r\n',15,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (92,'CHARLEs\r\n','FISHER\r\n','MALE\r\n','NON-TEACHING\r\n',40,15,'TRANSFERRED\r\n','MASTERS\r\n','AUGUST\r\n',19,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (93,'ROSE\r\n','BUTLER\r\n','FEMALE\r\n','TEACHING\r\n',22,20,'TRANSFERRED\r\n','BACHELORS\r\n','JULY\r\n',23,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (94,'SIMON\r\n','HUGHES\r\n','MALE\r\n','NON-TEACHING\r\n',20,25,'RETIRED\r\n','DOCTORATE\r\n\r\n','SEPTEMBER\r\n',25,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (95,'EVAN\r\n','GIBSON\r\n','MALE\r\n','TEACHING\r\n',25,30,'RESIGNED\r\n','MASTERS\r\n','NOVEMBER\r\n',18,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (96,'STEWART\r\n','SHORT\r\n','MALE\r\n','NON TEACHING\r\n',19,35,'RETIRED\r\n','MASTERS\r\n','JULY\r\n',20,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (97,'BELLA\r\n','AVERY\r\n','FEMALE\r\n','NON TEACHING\r\n',4,40,'RESIGNED\r\n','DOCTORATE\r\n','SEPTEMBER\r\n',23,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (98,'FELICITY\r\n','PIULLMAN\r\n','MALE\r\n','NON TEACHING\r\n',12,45,'TRANSFERRED\r\n','BACHELORS\r\n','MARCH\r\n',26,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (99,'KATHERINE\r\n','WRIGHT\r\n','FEMALE\r\n','TEACHING\r\n',43,5,'TRANSFERRED\r\n','BACHELORS\r\n','JUNE\r\n',31,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (100,'NEIL\r\n','INCE\r\n','MALE\r\n','NON TEACHING\r\n',24,10,'RETIRED\r\n','BACHELORS\r\n','JULY\r\n',13,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (101,'ROSE\r\n','INCE\r\n','FEMALE\r\n','NON TEACHING\r\n',6,15,'RESIGNED\r\n','DOCTORATE\r\n','MAY\r\n',25,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (102,'HARRY\r\n','TURKER\r\n','MALE\r\n','TEACHING\r\n',8,20,'RETIRED\r\n','MASTERS\r\n','DECEMBER\r\n',6,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (103,'RUTH\r\n','CORNISH\r\n','FEMALE\r\n','NON TEACHING\r\n',9,25,'RESIGNED\r\n','BACHELORS\r\n','OCTOBER\r\n',23,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (104,'NATALIE\r\n','WILKINS\r\n','FEMALE\r\n','TEACHING\r\n',26,30,'TRANSFERRED\r\n','BACHELORS\r\n','JANUARY\r\n',23,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (105,'JACK\r\n','WATSON\r\n','MALE\r\n','NON TEACHING\r\n',35,35,'RETIRED','BACHELORS\r\n','NOVEMBER\r\n',15,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (106,'PHIL\r\n','CORNISH\r\n','MALE\r\n','TEACHING\r\n',39,40,'RESIGNED\r\n','DOCTORATE\r\n','APRIL\r\n',16,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (107,'DOROTHY\r\n','GIBSON\r\n','FEMALE\r\n','NON TEACHING\r\n',31,5,'RETIRED','MASTERS\r\n','FEBRUARY\r\n',27,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (108,'VIRGINIA\r\n','WALSH\r\n','FEMALE\r\n','NON TEACHING\r\n',15,10,'RETIRED','BACHELORS\r\n','MARCH\r\n',28,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (109,'THERESA\r\n','HUNTER\r\n','FEMALE\r\n','TEACHING\r\n',5,15,'TRANSFERRED\r\n','DOCTORATE\r\n','SEPTEMBER\r\n',12,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (110,'KEVIN\r\n','CAMERON\r\n','MALE\r\n','TEACHING\r\n',7,20,'TRANSFERRED\r\n','MASTERS\r\n','AUGUST\r\n',14,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (111,'JOSHUA\r\n','DUNCAN\r\n','MALE\r\n','NON TEACHING\r\n',30,25,'RETIRED','MASTERS\r\n','JANUARY\r\n',17,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (112,'DIERDE\r\n','CAMERON\r\n','MALE\r\n','TEACHING\r\n',15,30,'RESIGNED\r\n','DOCTORATE\r\n','MAY\r\n',18,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (113,'WILLIAM\r\n','BROWN\r\n','MALE\r\n','NON TEACHING\r\n',18,35,'RETIRED','BACHELORS\r\n','JULY\r\n',26,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (114,'LUKE\r\n','PARSON\r\n','MALE\r\n','TEACHING\r\n',4,40,'RETIRED','BACHELORS\r\n','DECEMBER\r\n',27,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (115,'JOHN\r\n','WELCH\r\n','MALE\r\n','TEACHING\r\n',5,5,'RESIGNED\r\n','MASTERS\r\n','SEPTEMBER\r\n',29,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (116,'CHRISTINE\r\n','HILL\r\n','MALE\r\n','NON-TEACHING\r\n',10,10,'RETIRED','BACHELORS\r\n','AUGUST\r\n',18,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (117,'WARREN\r\n','HILL\r\n','MALE\r\n','NON-TEACHING\r\n',25,15,'RESIGNED\r\n','DOCTORATE\r\n','JANUARY\r\n',1,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (118,'BRIAN','ABRAHAM','MALE\r\n','TEACHING\r\n',24,35,'TRANSFERRED','DOCTORATE','DECEMBER\r\n',27,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (119,'HEATHER\r\n','TAYLOR\r\n','MALE\r\n','TEACHING\r\n',19,30,'TRANSFERRED\r\n','BACHELORS\r\n','FEBRUARY\r\n',23,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (120,'JULIA\r\n','CARR\r\n','FEMALE\r\n','NON TEACHING\r\n',32,40,'RETIRED','MASTERS\r\n','NOVEMBER\r\n',14,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (121,'DOMINIC\r\n','NEWMAN\r\n','MALE\r\n','NON TEACHING\r\n',38,5,'RESIGNED\r\n','BACHELORS\r\n','JUNE\r\n',12,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (122,'CLAIRE\r\n','NORTH\r\n','FEMALE\r\n','TEACHING\r\n',31,10,'RETIRED','BACHELORS\r\n','APRIL\r\n',13,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (123,'KEVIN\r\n','HUDSON\r\n','MALE\r\n','NON TEACHING\r\n',45,15,'RESIGNED\r\n','BACHELORS\r\n','DECEMBER\r\n',11,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (124,'JAKE\r\n','LEE\r\n','MALE\r\n','TEACHING\r\n',30,20,'TRANSFERRED\r\n','DOCTORATE\r\n','AUGUST\r\n',19,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (125,'EMILY\r\n','FRASER\r\n','FEMALE\r\n','NON TEACHING\r\n',14,25,'TRANSFERRED\r\n','MASTERS\r\n','JULY\r\n',25,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (126,'CAROLYN\r\n','ELISON\r\n','FEMALE\r\n','TEACHING\r\n',21,30,'RETIRED','BACHELORS\r\n','SEPTEMBER\r\n',27,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (127,'CAROLINE\r\n','BOWER\r\n','FEMALE\r\n','NON-TEACHING\r\n',36,35,'RESIGNED\r\n','DOCTORATE\r\n','NOVEMBER\r\n',23,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (128,'NICHOLAS\r\n','KNOX\r\n','MALE\r\n','TEACHING\r\n',3,40,'RETIRED','MASTERS\r\n','JULY\r\n',29,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (129,'ELIZABETH\r\n','GRAY\r\n','FEMALE\r\n','NON-TEACHING\r\n',7,45,'RESIGNED\r\n','MASTERS\r\n','JANUARY\r\n',12,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (130,'BORIS\r\n','TAYLOR\r\n','MALE\r\n','NON-TEACHING\r\n',9,5,'TRANSFERRED\r\n','DOCTORATE\r\n','NOVEMBER\r\n',16,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (131,'ELIZABETH\r\n','BOWER\r\n','FEMALE\r\n','TEACHING\r\n',12,10,'RETIRED','BACHELORS\r\n','APRIL\r\n',14,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (132,'PHIL\r\n','MCDONALD\r\n','MALE\r\n','NON-TEACHING\r\n',11,15,'RESIGNED\r\n','BACHELORS\r\n','FEBRUARY\r\n',18,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (133,'TIM\r\n','BALL\r\n','MALE\r\n','TEACHING\r\n',18,20,'RETIRED','BACHELORS\r\n','MARCH\r\n',12,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (134,'DAVID\r\n','NEWMAN\r\n','MALE\r\n','TEACHING\r\n',28,25,'RETIRED','DOCTORATE\r\n','SEPTEMBER\r\n',16,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (135,'ALAN\r\n','PULLMAN\r\n','MALE\r\n','NON-TEACHING\r\n',38,30,'TRANSFERRED\r\n','BACHELORS\r\n','AUGUST\r\n',1,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (136,'SAMANTHA\r\n','HUDSON\r\n','FEMALE\r\n','TEACHING\r\n',22,35,'TRANSFERRED\r\n','DOCTORATE\r\n','JANUARY\r\n',3,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (137,'VICTOR\r\n','STEWART\r\n','MALE\r\n','NON-TEACHING\r\n',11,40,'RETIRED','MASTERS\r\n','MAY\r\n',11,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (138,'LAUREN\r\n','WILSON\r\n','FEMALE\r\n','TEACHING \r\n',30,40,'RESIGNED\r\n','BACHELORS\r\n','JULY\r\n',10,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (139,'NICOLA\r\n','GRAY\r\n','FEMALE\r\n','TEACHING\r\n',10,45,'RESIGNED\r\n','BACHELORS\r\n','DECEMBER\r\n',17,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (140,'TREVOR\r\n','SPRINGER\r\n','MALE\r\n','NON-TEACHING\r\n',11,30,'RESIGNED\r\n','MASTERS\r\n','FEBRUARY\r\n',12,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (141,'TREVOR\r\n','Randall\r\n','MALE\r\n','TEACHING\r\n',14,35,'TRANSFERRED\r\n','DOCTORATE\r\n','OCTOBER\r\n',15,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (142,'AMELIA\r\n','RAMPLING\r\n','MALE\r\n','NON-TEACHING\r\n',40,40,'RETIRED','MASTERS\r\n','NOVEMBER\r\n',19,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (143,'GABRIELLE\r\n','SPRINGER\r\n','MALE\r\n','TEACHING\r\n',22,5,'RESIGNED\r\n','BACHELORS\r\n','JUNE\r\n',19,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (144,'RYAN\r\n','REES\r\n','MALE\r\n','NON-TEACHING\r\n',20,10,'RETIRED','DOCTORATE\r\n','APRIL\r\n',23,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (145,'MAX\r\n','HODGES\r\n','MALE\r\n','TEACHING\r\n',32,15,'RETIRED','MASTERS\r\n','DECEMBER\r\n',27,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (146,'JOAN\r\n','CARR\r\n','MALE\r\n','NON-TEACHING\r\n',8,20,'RESIGNED\r\n','BACHELORS\r\n','AUGUST\r\n',29,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (147,'MATT\r\n','FERGUSON\r\n','MALE\r\n','NON-TEACHING\r\n',34,25,'RESIGNED\r\n','BACHELORS\r\n','JULY\r\n',23,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (148,'HEATHER\r\n','JONSTON\r\n','MALE\r\n','TEACHING\r\n',38,30,'RESIGNED\r\n','BACHELORS\r\n','SEPTEMBER\r\n',27,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (149,'JULIA\r\n','BUTLER\r\n','FEMALE\r\n','NON-TEACHING\r\n',33,35,'TRANSFERRED\r\n','DOCTORATE\r\n','NOVEMBER\r\n',29,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (150,'EVAN\r\n','CLARKSON\r\n','MALE\r\n','TEACHING\r\n',38,40,'TRANSFERRED\r\n','MASTERS\r\n','JULY\r\n',30,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (151,'WANDA\r\n','HUGHES\r\n','FEMALE','NON-TEACHING\r\n',28,45,'RETIRED','BACHELORS\r\n','JANUARY\r\n',24,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (152,'TREVOR\r\n','PAYNE\r\n','MALE\r\n','TEACHING\r\n',4,5,'RESIGNED\r\n','BACHELORS\r\n','NOVEMBER\r\n',31,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (153,'DIANE\r\n','CLARK\r\n','FEMALE\r\n','NON-TEACHING\r\n',19,10,'RETIRED','BACHELORS\r\n','APRIL\r\n',25,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (154,'STEPHANIE\r\n','DAVIES\r\n','FEMALE\r\n','TEACHING\r\n',7,15,'RESIGNED\r\n','DOCTORATE\r\n','FEBRUARY\r\n',28,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (155,'PHIL\r\n','SMITH\r\n','MALE\r\n','NON-TEACHING\r\n',43,20,'TRANSFERRED\r\n','MASTERS\r\n','MARCH\r\n',1,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (156,'JOAN\r\n','FRASER\r\n','FEMALE\r\n','TEACHING\r\n',41,25,'RETIRED','BACHELORS\r\n','SEPTEMBER\r\n',12,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (157,'ALAN\r\n','FRASER\r\n','MALE\r\n','TEACHING\r\n',18,30,'RESIGNED\r\n','DOCTORATE\r\n','AUGUST\r\n',13,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (158,'NATHAN\r\n','JONATHAN\r\n','MALE\r\n','NON-TEACHING\r\n',19,35,'RETIRED','MASTERS\r\n','JANUARY\r\n',12,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (159,'DAN\r\n','OLIVER\r\n','MALE\r\n','NON-TEACHING\r\n',36,40,'RETIRED','MASTERS\r\n','MAY\r\n',1,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (160,'BLAKE\r\n','BAILEY\r\n','MALE\r\n','TEACHING \r\n',6,40,'TRANSFERRED\r\n','DOCTORATE\r\n','JULY\r\n',20,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (161,'LEOANRD\r\n','ABRAHAM\r\n','MALE\r\n','NON-TEACHING\r\n',18,45,'TRANSFERRED\r\n','BACHELORS\r\n','DECEMBER\r\n',14,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (162,'DOMINIC\r\n','BURGESS\r\n','MALE\r\n','TEACHING\r\n',13,30,'RETIRED','BACHELORS\r\n','FEBRUARY\r\n',10,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (163,'AVA','GLOVER','FEMALE','NON-TEACHING',1,35,'RESIGNED','BACHELORS','OCTOBER',27,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (164,'ADRIANE','WELCH','MALE','NON-TEACHING',28,40,'RESIGNED','DOCTORATE','NOVEMBER',13,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (165,'PETER','HUNTER','MALE','NON-TEACHING',20,5,'RESIGNED','MASTERS','JUNE',15,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (166,'ALEXANDER','PARR','MALE','NON-TEACHING',25,10,'TRANSFERRED','BACHELORS','APRIL',12,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (167,'ROBERT','ABRAHAM','MALE','TEACHING',14,15,'RETIRED','DOCTORATE','DECEMBER',8,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (168,'IRENE','VAUGHAN','FEMALE','NON-TEACHING',14,20,'RESIGNED','DOCTORATE','AUGUST',21,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (169,'AVA','HUGHES','FEMALE','TEACHING',21,25,'RETIRED','DOCTORATE','JULY',29,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (170,'HARRY','MANNING','MALE','NON-TEACHING',36,30,'RETIRED','BACHELORS','SEPTEMBER',18,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (171,'NEIL','HUGHES','MALE','TEACHING',3,35,'RESIGNED','BACHELORS','NOVEMBER',9,19);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (172,'SALLY','BLAKE','FEMALE','NON-TEACHING',7,40,'TRANSFERRED','DOCTORATE','JULY',15,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (173,'BELLA','POWELL','FEMALE','TEACHING',9,45,'TRANSFERRED','MASTERS','JANUARY',18,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (174,'BERNADETTE','STEWART','FEMALE','NON-TEACHING',12,5,'RETIRED','BACHELORS','NOVEMBER',24,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (175,'SEAN','CLARK','MALE','TEACHING',11,10,'RESIGNED','DOCTORATE','APRIL',14,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (176,'MAX','FISHER','MALE','NON-TEACHING',18,15,'RETIRED','MASTERS','FEBRUARY',5,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (177,'DAVID','COLEMAN','MALE','TEACHING',28,20,'RESIGNED','BACHELORS','MARCH',20,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (178,'GRACE','COLEMAN','MALE','NON-TEACHING',38,25,'TRANSFERRED','BACHELORS','SEPTEMBER',18,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (179,'RUTH','DOWD','MALE','TEACHING',22,30,'RETIRED','BACHELORS','AUGUST',19,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (180,'ANDREA','PIPER','MALE','NON-TEACHING',11,35,'RESIGNED','DOCTORATE','JANUARY',27,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (181,'JAKE','NASH','MALE','TEACHING',30,40,'RETIRED','MASTERS','MAY',26,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (182,'BENJAMIN','MILLER','MALE','NON-TEACHING',10,40,'RETIRED','BACHELORS','JULY',23,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (183,'NATALIE','SUTHERLAND','FEMALE','TEACHING',11,45,'TRANSFERRED','DOCTORATE','DECEMBER',24,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (184,'STEVEN','CLARKSON','MALE','NON-TEACHING',14,45,'TRANSFERRED','MASTERS','FEBRUARY',25,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (185,'UNA','MCLEAN','MALE','TEACHING',40,5,'RETIRED','MASTERS','OCTOBER',26,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (186,'LILY','LAWRENCE','FEMALE','NON-TEACHING',22,10,'RESIGNED','DOCTORATE','NOVEMBER',27,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (187,'MICHAEL','MACKY','MALE','TEACHING',20,15,'RESIGNED','BACHELORS','JUNE',28,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (188,'ABIGAIL','WHITE','FEMALE','NON-TEACHING',25,20,'RESIGNED','BACHELORS','APRIL',29,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (189,'AVA','RAMPLING','FEMALE','TEACHING',19,25,'TRANSFERRED','BACHELORS','DECEMBER',14,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (190,'ROSE','HENDERSON','FEMALE','NON-TEACHING',4,30,'RETIRED','DOCTORATE','AUGUST',16,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (191,'HANNAH','GRAHAM','FEMALE','TEACHING',12,35,'RESIGNED','BACHELORS','JULY',27,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (192,'SAM','MORGAN','MALE','NON-TEACHING',43,40,'RETIRED','DOCTORATE','SEPTEMBER',21,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (193,'AMANDA','BLAKE','FEMALE','TEACHING',24,40,'RETIRED','MASTERS','NOVEMBER',23,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (194,'UNA','WALSH','FEMALE','NON-TEACHING',6,45,'RETIRED','MASTERS','JULY',22,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (195,'VIRGINIA','FERGUSON','FEMALE','TEACHING',8,30,'RESIGNED','DOCTORATE','JANUARY',23,18);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (196,'DEIRDRE','LAMBERT','MALE','NON-TEACHING',9,35,'TRANSFERRED','BACHELORS','NOVEMBER',26,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (197,'JULIA','SIMPSON','FEMALE','TEACHING',26,40,'RETIRED','BACHELORS','APRIL',27,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (198,'JAMES','MILLER','MALE','NON TEACHING',35,5,'RESIGNED','BACHELORS','FEBRUARY',28,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (199,'ADRIAN','MATTHIS','MALE','TEACHING',39,10,'RETIRED','DOCTORATE','MARCH',18,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (200,'ISAAC','RANDALL','MALE','NON-TEACHING',31,15,'RETIRED','BACHELORS','SEPTEMBER',21,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (201,'BENJAMIN','BALL','MALE','TEACHING',15,20,'TRANSFERRED','DOCTORATE','AUGUST',9,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (202,'EDWARD','ROBERTSON','MALE','NON-TEACHING',5,25,'TRANSFERRED','MASTERS','JANUARY',10,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (203,'BRANDON','BERRY','MALE','TEACHING',7,30,'RETIRED','BACHELORS','MAY',7,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (204,'FELICITY','SHORT','FEMALE','NON-TEACHING',30,15,'RESIGNED','BACHELORS','JULY',6,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (205,'AUSTIN','DUNCAN','MALE','TEACHING',15,20,'TEACHING','MASTERS\r\n','DECEMBER\r\n',19,20);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (206,'CAROL\r\n','BROWN\r\n','FEMALE\r\n','NON-TEACHING\r\n',18,25,'RETIRED','DOCTORATE\r\n','FEBRUARY\r\n',20,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (207,'GABRIELLE\r\n','DICKENS\r\n','MALE\r\n','TEACHING\r\n',4,30,'TRANSFERRED\r\n','MASTERS\r\n','OCTOBER\r\n',27,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (208,'DIANNA\r\n','DIANNA\r\n','FEMALE\r\n','NON-TEACHING\r\n',19,35,'RETIRED','BACHELORS\r\n','NOVEMBER\r\n',6,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (209,'LILLIAN\r\n','CLARK\r\n','FEMALE\r\n','TEACHING\r\n',24,40,'RESIGNED\r\n','DOCTORATE\r\n','JUNE\r\n',17,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (210,'ELIZABETH\r\n','GRAHAM\r\n','FEMALE','NON-TEACHING',32,30,'RETIRED','MASTERS\r\n','APRIL\r\n',4,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (211,'BRANDON\r\n','SPRINGER\r\n','MALE\r\n','TEACHING\r\n',38,35,'RETIRED','BACHELORS\r\n','DECEMBER\r\n',24,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (212,'IAN\r\n','DUNCAN\r\n','MALE\r\n','NON-TEACHING\r\n',31,40,'RESIGNED\r\n','BACHELORS\r\n','AUGUST\r\n',19,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (213,'CAROL\r\n','GLOVER\r\n','FEMALE\r\n','TEACHING\r\n',45,5,'TRANSFERRED\r\n','BACHELORS\r\n','JULY\r\n',28,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (214,'ERIC\r\n','MORGAN\r\n','MALE\r\n','NON-TEACHING\r\n',30,10,'TRANSFERRED\r\n','DOCTORATE\r\n','SEPTEMBER\r\n',12,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (215,'GAVIN\r\n','SANDERSON\r\n','MALE\r\n','TEACHING\r\n',14,15,'RETIRED','MASTERS\r\n','NOVEMBER\r\n',19,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (216,'CAMERON\r\n','GLOVER\r\n','FEMALE\r\n','NON-TEACHING\r\n',21,20,'RESIGNED\r\n','BACHELORS\r\n','JULY\r\n',17,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (217,'JOE\r\n','TURNER\r\n','MALE\r\n','NON-TEACHING\r\n',36,25,'RETIRED','BACHELORS\r\n','AUGUST\r\n',22,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (218,'JOHN\r\n','KING\r\n','MALE\r\n','TEACHING\r\n',3,30,'RESIGNED\r\n','BACHELORS\r\n','JANUARY\r\n',2,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (219,'PETER\r\n','CORNISH\r\n','MALE\r\n','NON-TEACHING\r\n',7,35,'TRANSFERRED\r\n','DOCTORATE\r\n','MAY\r\n',5,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (220,'GABRIELLE\r\n','SANDERSON\r\n','MALE\r\n','NON-TEACHING\r\n',9,40,'RETIRED','MASTERS\r\n','MASTERS\r\n',11,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (221,'EVAN\r\n','ALSOP\r\n','MALE\r\n','TEACHING \r\n',12,45,'RESIGNED\r\n','BACHELORS\r\n','DECEMBER\r\n',18,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (222,'ANNE','DAVIDSON','FEMALE\r\n','NON-TEACHING\r\n',11,5,'RETIRED','DOCTORATE\r\n','FEBRUARY\r\n',22,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (223,'JOSHUA\r\n','HARRIS\r\n','MALE\r\n','TEACHING\r\n',18,10,'RETIRED','MASTERS\r\n','OCTOBER\r\n',14,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (224,'OLIVIA\r\n','STEWART\r\n','FEMALE\r\n','NON-TEACHING\r\n',28,15,'TRANSFERRED','MASTERS','NOVEMBER',5,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (225,'ROBERT','BUTLER','MALE','TEACHING\r\n',38,20,'TRANSFERRED\r\n','DOCTORATE\r\n','JUNE\r\n',2,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (226,'AUDREY','HART','FEMALE','NON-TEACHING',22,25,'RETIRED','BACHELORS','APRIL',8,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (227,'CAROLINE','SANDERSON','FEMALE','TEACHING',11,30,'RESIGNED','BACHELORS','DECEMBER',11,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (228,'OLIVER','GILL','MALE','NON-TEACHING',30,35,'RESIGNED','BACHELORS','AUGUST',9,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (229,'STEPHEN\r\n','LEE\r\n','MALE\r\n','TEACHING\r\n',10,40,'RESIGNED\r\n','DOCTORATE\r\n','JULY\r\n',26,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (230,'ANNE\r\n','SIMPSON\r\n','FEMALE\r\n','NON-TEACHING\r\n',11,40,'TRANSFERRED\r\n','MASTERS','SEPTEMBER',4,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (231,'LIAM','PETERS','MALE','TEACHING',14,45,'RETIRED','BACHELORS','NOVEMBER',5,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (232,'MAX','MILLER','MALE','NON-TEACHING',40,30,'RETIRED','DOCTORATE','JULY',20,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (233,'ANGELA','LANGDON','FEMALE','TEACHING',45,35,'RESIGNED','DOCTORATE','JANUARY',22,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (234,'JASMINE','PIPER','FEMALE','NON-TEACHING',30,40,'TRANSFERRED','DOCTORATE','NOVEMBER',4,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (235,'JOE','DICKENS','MALE','TEACHING',14,5,'RETIRED','BACHELORS','APRIL',12,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (236,'SIMON','HAMILTON','MALE','NON-TEACHING',21,10,'RESIGNED','BACHELORS','FEBRUARY',16,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (237,'JASON','GRANT','MALE','TEACHING',36,15,'RETIRED','DOCTORATE','MARCH',9,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (238,'MOLLY','UNDERWOOD','FEMALE','NON-TEACHING',3,20,'RETIRED','MASTERS','SEPTEMBER',15,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (239,'STEPHEN','HARRIS','MALE','TEACHING',17,25,'TRANSFERRED','BACHELORS','AUGUST',24,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (240,'HEATHER','KNOX','MALE','NON-TEACHING',9,30,'TRANSFERRED','DOCTORATE','JANUARY',7,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (241,'STEPHANIE','UNDERWOOD','FEMALE','TEACHING',12,35,'RETIRED','MASTERS','MAY',12,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (242,'ERIC','KNOX','MALE','NON-TEACHING',11,40,'RESIGNED','BACHELORS','JULY',9,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (243,'AVA','BAKER','FEMALE','TEACHING',18,45,'RESIGNED','BACHELORS','DECEMBER',6,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (244,'MICHAEL','CHAPMAN','MALE','NON-TEACHING',28,5,'RESIGNED','BACHELORS','FEBRUARY',20,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (245,'HEATHER','CORNISH','FEMALE','TEACHING',38,10,'TRANSFERRED','DOCTORATE','OCTOBER',4,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (246,'JUSTIN','PEAK','MALE','NON-TEACHING',22,15,'RETIRED','MASTERS','NOVEMBER',10,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (247,'SUE','MARTIN','FEMALE','TEACHING',11,20,'RESIGNED','BACHELORS','JUNE',23,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (248,'LIAM','RANDALL','MALE','NON-TEACHING',30,25,'RETIRED','DOCTORATE','APRIL',12,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (249,'CHARLES','GRAHAM','MALE','TEACHING ',10,30,'RETIRED','MASTERS','DECEMBER',22,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (250,'MEGAN','BLACK','FEMALE','NON-TEACHING',34,35,'RESIGNED','MASTERS','AUGUST',16,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (251,'JOHN','POWELL','MALE','TEACHING',14,40,'TRANSFERRED','DOCTORATE','JULY',24,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (252,'UNA','ALLAN','MALE','NON-TEACHING',40,40,'TRANSFERRED','BACHELORS','SEPTEMBER',19,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (253,'FAITH','KELLY','FEMALE','NON-TEACHING',22,20,'RETIRED','BACHELORS','NOVEMBER',27,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (254,'CONNOR','SLATER','MALE','TEACHING',20,25,'RESIGNED','DOCTORATE','JULY',25,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (255,'MICHELLE','BUTLER','MALE','NON-TEACHING',32,30,'RETIRED','MASTERS','JANUARY',11,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (256,'MADELIENE','MARTIN','MALE','TEACHING',8,35,'RESIGNED','MASTERS','NOVEMBER',5,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (257,'BELLA','PULLMAN','MALE','NON-TEACHING',34,40,'TRANSFERRED','DOCTORATE','APRIL',17,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (258,'WILLIAM','FORSYTH','FEMALE','TEACHING',38,45,'RETIRED','BACHELORS','FEBRUARY',18,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (259,'ERIC','SHARP','MALE','NON-TEACHING',33,5,'RESIGNED','BACHELORS','MARCH',25,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (260,'SIMON','NASH','MALE','TEACHING ',38,10,'RETIRED','BACHELORS','SEPTEMBER',17,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (261,'MATT','JAMES','MALE','NON-TEACHING',28,15,'RETIRED','DOCTORATE','AUGUST',19,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (262,'LILY','THOMSON','MALE','TEACHING',4,20,'TRANSFERRED','BACHELORS','JANUARY',20,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (263,'KYLIE','SIMPSON','MALE','NON-TEACHING',19,25,'TRANSFERRED','DOCTORATE','MAY',22,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (264,'ZOE','CAMERON','FEMALE','TEACHING',7,30,'RETIRED','MASTERS','JULY',16,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (265,'EMMA','DUNCAN','MALE','TEACHING',43,35,'RESIGNED','BACHELOR','DECEMBER',28,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (266,'STEPHEN','GRAHAM','FEMALE','NON-TEACHING',41,40,'RESIGNED','BACHELORS','FEBRUARY',24,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (267,'COLIN','MURRAY','FEMALE','TEACHING',18,40,'RESIGNED','MASTERS','AUGUST',3,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (268,'PETER','ROBERTS','MALE','NON-TEACHING',19,45,'TRANSFERRED','DOCTORATE','JANUARY',7,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (269,'ALEXANDER','BERRY','FEMALE','TEACHING',36,30,'RETIRED','MASTERS','MAY',25,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (270,'ERIC','ROBERTSON','MALE','TEACHING',6,35,'RETIRED','BACHELORS','JULY',16,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (271,'HEATHER','SUTHERLAND','FEMALE','NON-TEACHING',18,40,'RESIGNED','DOCTORATE','DECEMBER',21,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (272,'ZOE','MORGAN','MALE','TEACHING',13,5,'TRANSFERRED','MASTERS','FEBRUARY',20,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (273,'EMILY','ARNOLD','MALE','TEACHING',1,10,'RETIRED','BACHELORS','OCTOBER',22,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (274,'KIMBERLY','MURRAY','FEMALE','NON TEACHING',28,15,'RESIGNED','BACHELORS','NOVEMBER',26,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (275,'DONNA','MORGAN','MALE','NON-TEACHING',20,20,'RETIRED','BACHELORS','JUNE',15,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (276,'DONNA','POWELL','MALE','NON-TEACHING',25,25,'RETIRED','DOCTORATE','APRIL',7,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (277,'STEPHANIE','KELLY\r\n','FEMALE\r\n','NON-TEACHING',14,30,'TRANSFERRED\r\n','MASTERS','DECEMBER',6,10);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (278,'JAN','HART','FEMALE','TECHING\r\n',14,35,'TRANSFERRED','BACHELORS\r\n','AUGUST',15,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (279,'DIANE','INCE\r\n','FEMALE\r\n','TEACHING \r\n',21,40,'RETIRED\r\n\r\n','BACHELORS\r\n','JULY',10,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (280,'ANDREW','GRAY','MALE','NON-TEACHING',36,45,'RESIGNED','BACHELORS\r\n','SEPTEMBER\r\n',16,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (281,'DIANNA\r\n','GREENE','FEMALE','TEACHING\r\n',3,5,'RESIGNED\r\n','DOCTORATE','NOVEMBER',20,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (282,'CARL','HART','FEMALE','NON-TEACHING',7,10,'RESIGNED','MASTERS','JULY',30,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (283,'GAVIN','WILSON','MALE','TEACHING',9,15,'TRANSFERRED','BACHELORS','JANUARY',4,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (284,'WARREN','ROBERTSON','MALE','NON-TEACHING',12,20,'RETIRED','DOCTORATE','NOVEMBER',29,11);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (285,'STEPHANIE','BOND','MALE','TEACHING',14,25,'RESIGNED','MASTERS','APRIL',18,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (286,'PETER','ROBERTSON','MALE','NON-TEACHING',18,30,'RETIRED','MASTERS','FEBRUARY',17,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (287,'PIERS','ALSOP','MALE','TEACHING',28,35,'RETIRED','DOCTORATE','MARCH',5,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (288,'GORDON','HENDERSON','MALE','NON-TEACHING',38,40,'RESIGNED','BACHELORS','SEPTEMBER',3,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (289,'DONNA','MACDONALD','MALE','TEACHING',22,40,'TRANSFERRED','BACHELORS','AUGUST',18,5);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (290,'LISA','PARR','MALE','NON-TEACHING',11,45,'TRANSFERRED','BACHELORS','JANUARY',16,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (291,'RUTH','CAMPBELL','FEMALE','TEACHING',30,30,'RETIRED','DOCTORATE','MAY',19,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (292,'ABIGAIL','PULLMAN','MALE','NON-TEACHING',10,35,'RESIGNED','MASTERS','JULY',10,13);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (293,'JOHN','QUINN','FEMALE','TEACHING',11,40,'RETIRED','BACHELORS','DECEMBER',1,14);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (294,'JULIA','DYER','MALE','NON-TEACHING',14,5,'RESIGNED','DOCTORATE','FEBRUARY',13,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (295,'RYAN','GIBSON','MALE','TEACHING',40,10,'TRANSFERRED','DOCTORATE','OCTOBER',3,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (296,'STEPHEN','BALL','FEMALE','NON-TEACHING',22,15,'RETIRED','DOCTORATE','NOVEMBER',7,6);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (297,'JOAN','FORSYTH','FEMALE','NON-TEACHING',20,20,'RESIGNED','BACHELORS','JUNE',12,8);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (298,'CAROL','GIBSON','MALE','NON-TEACHING',25,25,'RETIRED','BACHELORS','APRIL',13,9);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (299,'IRENE','ROBERTSON','MALE','NON-TEACHING',19,30,'RETIRED','DOCTORATE','DECEMBER',8,7);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (300,'LUKE','MILLS','MALE','TEACHING',4,15,'TRANSFERRED','MASTERS','AUGUST',5,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (301,'CAMERON','MCLEAN','MALE','NON-TEACHING',12,20,'TRANSFERRED','BACHELORS','JULY',17,15);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (302,'CAROLYN','MAY','FEMALE','NON-TEACHING',43,25,'RETIRED','DOCTORATE','SEPTEMBER',14,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (303,'PIPPA','CAMPBELL','FEMALE','NON-TEACHING',24,30,'RESIGNED','MASTERS','NOVEMBER',19,12);
insert  into `emp_records`(`emp_id`,`firstname`,`lastname`,`gender`,`personnel`,`years_service`,`loyalty_awards`,`turn_over`,`education`,`birth_month`,`birthday_day`,`leaves`) values (304,'ANNA','JACKSON','MALE','TEACHING',16,35,'RESIGNED','BACHELORS','JULY',4,5);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

   



No comments:

Post a Comment