1. Create a query to display the last name and salary of employees earning more than $12,000.
  
2. Create a query to display the employee last name and department number for employee number
   176.

3. Display the last name and salary for all employees whose salary is 
   not in the range of $5,000 and $12,000

4. Display the employee last name, job ID, and start date of employees hired between February 
   20, 1998, and May 1, 1998. Order the query in ascending order by start date.

5. Display the last name and department number of all employees in departments 20 and 50 in 
   alphabetical order by name.

6. List the last name and salary of employees who earn between $5,000 
   and $12,000, and are in department 20 or 50. Label the columns Employee and Monthly 
   Salary, respectively.

7. Display the last name and hire date of every employee who was hired in 1994.

8. Display the last name and job title of all employees who do not have a manager.

9. Display the last name, salary, and commission for all employees who earn commissions. Sort
   data in descending order of salary and commissions.

10. Display the last names of all employees where the third letter of the name is an a.

11. Display the last name of all employees who have an a and an e in their last name.

12. Display the last name, job, and salary for all employees whose job is sales representative or 
    stock clerk and whose salary is not equal to $2,500, $3,500, or $7,000.

13. Display the last name, salary, and commission for all employees 
    whose commission amount is 20%.