Categories
Delphi

Addition of Three Numbers in Delphi

A very simple program to ask the user to give three numbers and then the program will sum the values of three numbers and display the results on the screen using Delphi 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
Program Listing

add_three_numbers.pas

unit add_three;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls;

type
  TForm1 = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Label6: TLabel;
    Edit4: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
  Var a,b,c : integer;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
a:= strtoint(edit1.text);
b:= strtoint(edit2.text);
c:= strtoint(edit3.text);
edit4.text := inttostr(a+b+c);
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
edit1.text := '';
edit2.text := '';
edit3.text := '';
edit4.text := '';
edit1.setfocus;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
if MessageDlg('Do you want to quit this program?', mtConfirmation, [mbYes, mbNO], 0) = mrYes then
begin
form1.Close;
end
else
begin
edit1.SetFocus;
end;
end;

end.
Categories
JQuery

Addition of Three Numbers in JQuery

I  wrote this simple program that I wrote using JQuery a JavaScript library to ask the user to give three numbers and then the program will sum the values of three numbers and display the results on the screen.
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
Sample Program Output
Program Listing

index.htm

<!doctype html>
<html>
<head>
     <script type='text/javascript' src='jquery/jquery.min.js'></script>
   <script type='text/javascript' src='add.js'></script>
</head>
<body>
 <h2> Addition of Three Numbers in JQuery </h2>
    <h4><i> Author Jake R. Pomperada,MAED-IT </i></h4>
 <br>
Enter the First number : <input id="first"><br>
Enter the Second number: <input id="second"><br>
Enter the Third number: <input id="third"><br><br>
The total sum is <input id="answer"><br><br>
<button id="btnAdd">Add</button>
<button id="btnClear">Clear</button>

</body>
</html>

add.js

// Code By Jake R. Pomperada,MAED-IT
// February 25, 2020

$(document).ready(function(){

$("#btnAdd").click(function(){
  var a,b,c;
a=Number(document.getElementById("first").value);
b=Number(document.getElementById("second").value);
c=Number(document.getElementById("third").value);
d= a + b+c;
document.getElementById("answer").value= d;

});



$("#btnClear").click(function(){

 document.getElementById('first').value="";
 document.getElementById('second').value="";
 document.getElementById('third').value="";
 document.getElementById('answer').value="";
 document.getElementById('first').focus();

});
});
Categories
JQuery

Vowels and Consonants Counter Using JQuery

I wrote this program that will ask the user to give a string or a sentence and then the program will count the number of vowels and consonants using JQuery. I integrate this code as an extension to a google chrome web browser this will be my first time to create an extension or plugin to a web browser.


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
Sample Program Output

DOWNLOAD SOURCE CODE HERE

Categories
C++

cout in C++

I wrote this program to show how to declare and use the cout statement in the C++ programming language. I am using code blocks as my text editor and g++ as my c++ compiler in writing this simple program.


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.

Home

https://www.unlimitedbooksph.com/

Sample Program Output

Program Listing
// cout.cpp
// February  19, 2020
// Bacolod City, Negros Occidental Philippines

#include <iostream>

using namespace std;


int main()
{
    cout <<"\n\n";
    cout <<"\tAuthor : Jake Rodriguez Pomperada";
    cout <<"\n\n";
    cout << "\tSample Text Display Using cout in C++";
    cout <<"\n\n";
    cout <<"\tEnd of Program";
    cout <<"\n\n";
}
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>"
?>
Categories
PHP

Insert Records in Two Tables in PHP and MySQL

 wrote this code for my capstone project in my studies that enable the user to save records in two different tables using PHP and MySQL. I try to do some research on the Internet to find this code but fail so I decided to write one for my self and to share with other people who are in need of this code.


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
Sample Program Output

Download Complete Source Code Here

Categories
PHP

Fetch Records From Two Tables Using PHP and MySQLi

I wrote this code to show how to use an inner join to fetch records from two tables in the database using PHP and MySQL. The code is very easy and easy to understand for beginners in PHP and MySQL programming.

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

Download the complete source code here

Categories
C

Decimal To Binary Number Converter

I wrote this program that will ask the user to give the decimal number and then the program will convert the given decimal number into binary number equivalent using the C 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

Program Listing

binary.c

#include<stdio.h>
#include<conio.h>

int main()
{
long int d;
int i=0,a[25],j;
printf("\tDecimal To Binary Number Converter");
printf("\n\n");
printf("Enter the Decimal No.:");
scanf("%d",&d);
while(d>0)
{
a[i]=d%2;
d=d/2;
i++;
}
printf("Binary Number Equivalent : ");
for (j=i-1;j>=0;j--)
printf("%d",a[j]);
getch();
}