Employees sample database for MySQL
A ready-to-run MySQL script with an HR table: departments, titles, hire dates, salaries and managers. Tested on MySQL 8.4.13. Updated 19 November 2026.
Employees database for MySQL
Each row is one fictional employee: department, job title, hire date, salary, office, manager and performance rating. The first eight rows are department heads; everyone else reports to a manager_id in the file.
This page has it as a MySQL script: one table and 1,000 rows, with column types chosen for MySQL, primary keys. The script drops the table if it exists, creates it and inserts the rows in one transaction, so you can run it again to reset the data. It is the same fictional data, seed 42, as on the employees dataset page, where it is also available as CSV and Excel.
We loaded this exact file into MySQL 8.4.13 and ran every question below on it; the answers shown are that output. The same questions, written for SQLite, PostgreSQL, MySQL, SQL Server and DuckDB, return the same results on all five.
Load it
mysql client
mysql -u root -p -e "CREATE DATABASE practice"
mysql -u root -p practice < employees-mysql.sqlMySQL Workbench
File > Open SQL Script, choose the database with USE practice; then Execute.
Tables and columns
employees 1,000 rows
| Column | MySQL type |
|---|---|
| employee_id | VARCHAR(10) |
| first_name | VARCHAR(20) |
| last_name | VARCHAR(20) |
| VARCHAR(40) | |
| department | VARCHAR(20) |
| job_title | VARCHAR(30) |
| hire_date | DATE |
| salary | INT |
| location | VARCHAR(10) |
| manager_id | VARCHAR(10) |
| employment_type | VARCHAR(20) |
| performance_rating | INT |
Practice questions
answers from MySQL 8.4.13
How many employees and what average salary does each department have?
SQL
SELECT department, COUNT(*) AS employees, ROUND(AVG(CAST(salary AS DECIMAL(18,4))), 2) AS avg_salary
FROM employees
GROUP BY department
ORDER BY avg_salary DESC, department;The cast to DECIMAL keeps the average exact before rounding.
Result
| department | employees | avg_salary |
|---|---|---|
| Engineering | 231 | 118,499.13 |
| Finance | 98 | 85,516.33 |
| IT | 73 | 79,419.18 |
| Marketing | 92 | 73,951.09 |
| Sales | 157 | 71,821.02 |
| Human Resources | 54 | 70,888.89 |
| Operations | 138 | 70,050.00 |
| Customer Support | 157 | 65,672.61 |
Who are the 5 highest-paid employees?
SQL
SELECT employee_id, first_name, last_name, department, salary
FROM employees
ORDER BY salary DESC, employee_id
LIMIT 5;LIMIT n at the end returns the first n rows.
Result
| employee_id | first_name | last_name | department | salary |
|---|---|---|---|---|
| E1002 | Priya | Khan | Engineering | 222800 |
| E1482 | Wei | Kim | Engineering | 185700 |
| E1195 | James | Khan | Engineering | 184100 |
| E1875 | Karen | Martinez | Engineering | 180900 |
| E1092 | James | Young | Engineering | 179600 |
Show each of the first 8 employees (by id) next to their manager's name. (self-join)
SQL
SELECT e.employee_id, CONCAT(e.first_name, ' ', e.last_name) AS employee,
CASE WHEN m.employee_id IS NOT NULL THEN CONCAT(m.first_name, ' ', m.last_name) END AS manager
FROM employees e
LEFT JOIN employees m ON m.employee_id = e.manager_id
ORDER BY e.employee_id
LIMIT 8;CONCAT(a, b, ...) joins strings; || is not string concatenation by default.
Result
| employee_id | employee | manager |
|---|---|---|
| E1001 | Patricia Anderson | |
| E1002 | Priya Khan | |
| E1003 | Thomas Robinson | |
| E1004 | Kimberly Lopez | |
| E1005 | Emma Jackson | |
| E1006 | Joseph Johnson | |
| E1007 | Priya Gonzalez | |
| E1008 | Mary Moore |
How many people were hired each year since 2020?
SQL
SELECT YEAR(hire_date) AS hire_year, COUNT(*) AS hires
FROM employees
WHERE YEAR(hire_date) >= 2020
GROUP BY YEAR(hire_date)
ORDER BY hire_year;YEAR(date) returns the year as a number.
Result
| hire_year | hires |
|---|---|
| 2020 | 75 |
| 2021 | 74 |
| 2022 | 87 |
| 2023 | 77 |
| 2024 | 83 |
Who is the highest-paid person in each department? (window function)
SQL
WITH r AS (
SELECT department, employee_id, first_name, last_name, salary,
ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC, employee_id) AS rn
FROM employees
)
SELECT department, employee_id, first_name, last_name, salary
FROM r
WHERE rn = 1
ORDER BY department;Window functions need MySQL 8.0 or later.
Result
| department | employee_id | first_name | last_name | salary |
|---|---|---|---|---|
| Customer Support | E1007 | Priya | Gonzalez | 110700 |
| Engineering | E1002 | Priya | Khan | 222800 |
| Finance | E1004 | Kimberly | Lopez | 162000 |
| Human Resources | E1005 | Emma | Jackson | 132300 |
| IT | E1008 | Mary | Moore | 159300 |
| Marketing | E1003 | Thomas | Robinson | 141800 |
| Operations | E1006 | Joseph | Johnson | 137700 |
| Sales | E1001 | Patricia | Anderson | 132300 |
How does average salary change with performance rating?
SQL
SELECT performance_rating, COUNT(*) AS employees, ROUND(AVG(CAST(salary AS DECIMAL(18,4))), 2) AS avg_salary
FROM employees
GROUP BY performance_rating
ORDER BY performance_rating;The cast to DECIMAL keeps the average exact before rounding.
Result
| performance_rating | employees | avg_salary |
|---|---|---|
| 1 | 33 | 72,330.30 |
| 2 | 131 | 88,623.66 |
| 3 | 447 | 81,907.61 |
| 4 | 278 | 82,866.55 |
| 5 | 111 | 88,200.00 |
MySQL differences used here
- The cast to DECIMAL keeps the average exact before rounding.
- CONCAT(a, b, ...) joins strings; || is not string concatenation by default.
- LIMIT n at the end returns the first n rows.
- Window functions need MySQL 8.0 or later.
- YEAR(date) returns the year as a number.