Click any of the query buttons on the web page to query the database.
The results of the query will be displayed on the web page.
Queries supported:
- Department names
- Titles
- Amount of employees per department
- Amount of employees per title
- Present average salaries per department
- Present average salaries per title
- Amount of employees per year
- Average salaries per year for department
- Average salaries per year for title
The database is populated with sample data from - https://dev.mysql.com/doc/employee/en/