Applied Arts & Technology
SCHOOL OF COMPUTER STUDIES
BTD - 310
Lab Assignment Sub Quires
1. Write a query to display the last name and hire date of any employee in the same department with ’Zlotkey’.
Don’t show Mr. Zlotkey.
2. Create a query to display the employee numbers and last names of all employees who earn more than the average
salary of all employees. Sort the results in ascending order of salary.
3. Write a query that displays the employee numbers and last names of all employees who work in a department with
any employee whose last name contains a u.
4. Display the last