I would like some help with a very small project that I am working on.
I have completed the required database in MS Access. The requirements for my project are below:
1. Group employees by salary within job titles that are grouped into exempt and non-exempt.
2. Use UNION to create a third table of employee names, job titles and salary.
Create SQL statements that will satisfy the above requirements.