Month: February 2020

Delphi

Addition of Three Numbers in Delphi

Post author By jakerpomperada
Post date February 25, 2020
No Comments on 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.

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/

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.

Tags delphi, delphi sum of two numbers, pascal programming, sum of three numbers in delphi

JQuery

Addition of Three Numbers in JQuery

Post author By jakerpomperada
Post date February 25, 2020
No Comments on 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

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();

});
});

Tags addition of three numbers, Addition of Three Numbers in JQuery, bacolod city, c++, jake pomperada, javascript, javascript programming, jquery, programmer, software engineer, sum of two numbers

JQuery

Vowels and Consonants Counter Using JQuery

Post author By jakerpomperada
Post date February 25, 2020
No Comments on 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.

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.

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

DOWNLOAD SOURCE CODE HERE

Tags consonants jquery, jake pomperada, javascript programs, jquery, js, programming, vowels in jquery, web programming

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";
}

Tags c programming, c programs, cout, cout in C++, jake pomperada, problem solving in c++, programs in c++

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/

<!DOCTYPE html>
<html>
<body>
<h1> Current Year in PHP </h1>
<?php
echo "<h1> This Year is " . date("Y") . "</h1><br>";
?>
</body>
</html>

Tags Current Year in PHP, jake pomperada, php, php programming, programming, software, web development, year in php

PHP

Current Month Checker With PHP and MYSQLi

Post author By jakerpomperada
Post date February 19, 2020
No Comments on 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/

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

Tags c++, current month in php, jake pomperada, mysql, php, php programming, web design, web development

PHP

Echo Statement in PHP

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

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/

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

Tags echo in php, jake pomperada, php, php programming, web development, web programming

PHP

Insert Records in Two Tables in PHP and MySQL

Post author By jakerpomperada
Post date February 12, 2020
No Comments on 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.

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/

Download Complete Source Code Here

Tags Insert Records in Two Tables in PHP and MySQL, jake pomperada, mysqli, php, php programming, php programs

PHP

Fetch Records From Two Tables Using PHP and MySQLi

Post author By jakerpomperada
Post date February 12, 2020
No Comments on 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/

Download the complete source code here

Tags Fetch Records From Two Tables Using PHP and MySQLi, jake pomperada, mysql, mysqli, php programming, php programs

Decimal To Binary Number Converter

Post author By jakerpomperada
Post date February 10, 2020
No Comments on 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.

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/

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();
}

Tags basic c programs, c programming, c programs, decimal to binary, decimal to binary in c, jake pomperada