Categories
C++

cout in C++

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


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

My mobile number here in the Philippines is 09173084360.

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

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


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

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

Home

https://www.unlimitedbooksph.com/

Sample Program Output

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

#include <iostream>

using namespace std;


int main()
{
    cout <<"\n\n";
    cout <<"\tAuthor : Jake Rodriguez Pomperada";
    cout <<"\n\n";
    cout << "\tSample Text Display Using cout in C++";
    cout <<"\n\n";
    cout <<"\tEnd of Program";
    cout <<"\n\n";
}
Categories
PHP

Current Year in PHP

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

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.

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


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

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

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


https://www.mindshaperspublishing.com/

https://www.unlimitedbooksph.com/

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

Current Month Checker With PHP and MYSQLi

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


My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.

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

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

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

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

I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/

https://www.unlimitedbooksph.com/

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


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

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

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

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

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


   


employee.sql

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


/*!40101 SET NAMES utf8 */;

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

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

USE `employee`;

/*Table structure for table `emp_records` */

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

/*Data for the table `emp_records` */

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

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

Categories
PHP

Echo Statement in PHP

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

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

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.


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

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

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

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

Home

https://www.unlimitedbooksph.com/

Sample Program Output

index.php

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

Insert Records in Two Tables in PHP and MySQL

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


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


My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.


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


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

I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/

https://www.unlimitedbooksph.com/

Sample Program Output
Sample Program Output

Download Complete Source Code Here

Categories
PHP

Fetch Records From Two Tables Using PHP and MySQLi

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

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.


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

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

I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/

https://www.unlimitedbooksph.com/

Sample Program Output

Download the complete source code here

Categories
C

Decimal To Binary Number Converter

I wrote this program that will ask the user to give the decimal number and then the program will convert the given decimal number into binary number equivalent using the C programming language.

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

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.


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

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

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


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

https://www.mindshaperspublishing.com/

https://www.unlimitedbooksph.com/

Sample Program Output

Program Listing

binary.c

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

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

Do You Want To Continue in C

A simple program to show you how to integrate do you want to continue option using the C programming language.

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

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.


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

My personal website is http://www.jakerpomperada.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/

Program Listing

/* sum.c
   Written By: Jake R. Pomperada,MAED-IT
   September 19, 2019  */

#include <stdio.h>
#include <ctype.h>

int main() {
	
int x=0,y=0,sum=0;
char ch;
do {
printf("\n");
printf("\tAddition of Two Numbers Using Do While in C");
printf("\n\n");
printf ("\tEnter the first number : ");
scanf ("%d",&x);
printf ("\tEnter the second number : ");
scanf ("%d",&y);
sum=x+y;
printf("\n");
printf ("\tThe total number is: %d\n",sum);
printf("\n\n");
printf ("\tDo you want to repeat the operation Y/N: ");
scanf (" %c", &ch);
} while (toupper(ch) == 'Y');
printf("\n\n");
printf ("\tEnd of Program");
printf("\n\n");
}
Categories
C++

Palindrome Number Checker in C++

I wrote this program that will ask the user to give integer and then the program will determine and check if the given number is a palindrome or not a palindrome using a C++ programming language.


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

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.


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

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

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

I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/
https://www.unlimitedbooksph.com/

My video tutorial on my YouTube Channel.
Sample Program Output
Sample Program Output

Program Listing

palindrome.cpp

#include <iostream>
#include <stdlib.h>

using namespace std;


int main()
{
    int n=0,num=0,digit=0,rev=0;
    
    cout <<"\n\n";
    cout <<"\tPalindrome Number Checker in C++ ";
    cout <<"\n\n";
    cout <<"\tGive a Positive Number : ";
    cin >> num;
    
    n = num;
    
    do {
        digit = num % 10;
        rev   = (rev * 10) + digit;
        num = num / 10;
        } while (num !=0);
        
    cout << "\tThe reverse of number is " << rev <<"\n";
    cout <<"\n\n";
    if (n == rev) {
          cout << "\tThe given number " << n<< " is a Palindrome.";
          }
         else {
                    cout << "\tThe given number " << n << " is  Not a Palindrome.";    
              }
                     
    cout <<"\n\n";
    cout << "\tEnd of the Program"; 
    cout <<"\n\n";     
    system("pause");
     }
     
Categories
C++

Leap Year Checker in C++

I wrote this simple program in C++ to ask the user to give a year and then the program will check and determine if the year is a leap year or not a leap year.

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


My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

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


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

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

I am also a book author you can purchase my books on computer programming and information technology in the following links below.
https://www.mindshaperspublishing.com/
https://www.unlimitedbooksph.com/

My tutorial video in my YouTube channel

Sample Program Output
Sample Program Output

Program Listing

leap_year.cpp

#include <iostream>
#include <stdlib.h>

using namespace std;

int main()
{
    int year=0;

    cout <<"\n\n";
    cout <<"\tLeap Year Checker in C++";
    cout <<"\n\n";
    cout <<"\tGive a Year : ";
    cin >> year;
    cout <<"\n\n";
        
    if (year % 4 == 0) 
    {
      if (year % 100 == 0) 
       {
          if (year % 400 == 0)
               cout <<"\t"<< year << " is a Leap Year.";
             else
               cout <<"\t"<< year << " is Not a Leap Year.";              
       }       
     else 
        cout <<"\t"<< year << " is a Leap Year.";
        }
     else 
      cout <<"\t"<< year << " is Not a Leap Year.";    
      
    cout <<"\n\n";
    cout <<"\tEnd of Program";
    cout <<"\n\n";  
    system("pause");
}