Categories
PHP

Foreach Statement in PHP

 I wrote this program to show how to use foreach statement using PHP programming language.

I am currently accepting programming work inventory system, enrollment system, accounting system, payroll system, information system, website design and development using WordPress, IT projects, school and application development, programming projects, thesis, and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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/

<?php
$grades[]=80;
$grades[]=81;
$grades[]=82;
$grades[]=83;
$grades[]=84;
$grades[]=85;

echo "<h4>Foreach Statement in PHP </h4>";
foreach($grades as $result){
  echo "Student Grade :  $result<br>";
}
echo "<p>End of Program</p>";
echo "<br>";
?>
Categories
PHP

Employees Records Pagination and Printing of Reports Using PHP and MySQL

 wrote this program for my capstone project in my Masters of Information Technology studies. This program will allow the user to search and print employees records using PHP,MySQL,JQuery and Data Tables. I hope that this code will help you in your web development projects.

I am currently accepting programming work inventory system, enrollment system, accounting system, payroll system, information system, website design and development using WordPress, IT projects, school and application development, programming projects, thesis, and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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
Sample Program Output
Printing of Reports of Employees Records

Download the Complete Source Code Here For FREE

Categories
PHP

Remove Special Characters in String in PHP

I wrote this program to remove any special characters in a given string except A-Z, a-z, 0-9, white space or a hyphen using PHP programming language.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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.comMy 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
<?php

//String containing special characters.
$username = "&&F2018-201%^%^%^ &&jake ##pomperada ))_bacolod''''*&&";

function Remove_Special_Char($str_value){
//Remove any character that isn't A-Z, a-z, 0-9, white space or a hyphen.
$str_value = preg_replace("/[^A-Za-z0-9- ]/", '', $str_value);
return $str_value;
}
echo Remove_Special_Char($username);
?>
Categories
PHP

Print Statement in PHP

Here is a simple program that I wrote to demonstrate how to use print statements in the PHP programming language.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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
<?php

$names ='Jake R. Pomperada';
$age = 41;

print "<h3>print statement in PHP </h3>";
print "My Name is $names. <br>";
print "My Age is $age years old.";
?>
Categories
PHP

Remove Single Quotes in PHP

A simple program that I wrote that will remove single quotes or quotations in a given string in PHP programming language.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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

<?php

 $str ="High's School's";
 
 $remove = str_replace("'", "", $str);
 
 echo $remove;
 
 ?>


Categories
PHP

Do While Loop in PHP

A simple program that I wrote in PHP to display a series of values using Do While Loop statement the code is very simple and easy to understand.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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.comMy 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
<?php
$x = 1;

echo "Do While Loop in PHP";
echo "<br><br>";

do {
    echo "The number is $x <br>";
    $x++;
} while ($x <= 20);
?>
Categories
PHP

Objects in PHP

The program that I wrote that will show you how to declare a class and objects in PHP programming language.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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.comMy 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
<?php

// Written By Jake R. Pomperada
// March 8, 2020
// Bacolod City

class Person {
  // Properties
  public $name;
  public $age;


  // Methods
  function set_name($name) {
    $this->name = $name;
  }
  
  function get_name() {
    return $this->name;
  }

 function set_age($age) {
    $this->age = $age;
  }
  
  function get_age() {
    return $this->age;
  }



}

$Allan = new Person();
$Maria = new  Person();
$Allan->set_name('Allan');
$Maria->set_name('Maria');

$Allan->set_age(35);
$Maria->set_age(42);

echo "<br>";
echo "<h4>Objects in PHP</h4>";
echo "<br>";
echo "Persons 1 Name :".$Allan->get_name()."<br>";
echo "Persons 1 Age  : ".$Allan->get_age()."<br>";
echo "<br>";
echo "Persons 2 Name :".$Maria->get_name()."<br>";
echo "Persons 2 Age  : ".$Maria->get_age()."<br>";
echo "<br>";
?>
Categories
PHP

Current Year in PHP

I wrote this simple program to display the current date based on
the computer date and time using PHP as my programming language.

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.comMy 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
<!DOCTYPE html>
<html>
<body>
<h1> Current Year in PHP </h1>
<?php
echo "<h1> This Year is " . date("Y") . "</h1><br>";
?>
</body>
</html>
Categories
PHP

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
<?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 */;

Categories
PHP

Echo Statement in PHP

I wrote this simple program using PHP programming language to show how to use the echo statement in PHP.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

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.

Home

https://www.unlimitedbooksph.com/

Sample Program Output

index.php

<?php
echo "<h1>Welcome To PHP Programming</h1>";
echo("<h2>Can you visit www.jakerpomperada.blogspot.com </h2><br>");
echo "<i> End of Program </i>"
?>