Assignment:
1. Using Microsoft SQL Server 2000
1. Database Tables
TABLE: Employees
Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Hire_date
Salary
TABLE: Job_title
Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary
2. Queries using the SQL GROUP statement:
A. Group employees by salary within their job code: Select the employee's last name and group them by salary within their job_title_code.
B. Select the employee's last name and group them by salary within job titles that are grouped into exempt and non-exempt.