6. The HR department wants a query to display the last name, job ID, hiredate, and employee ID for each employee, with the employee ID appearing first. Provide an alias STARTDATE for the HIRE_DATE column.

7. The HR department wants a query to display all unique job IDs from the EMPLOYEES table.

Task 3

8. The HR department wants more descriptive column headings for its report on employees. Name the column headings Emp #, Employee, Job, and Hire Date, respectively. Then run the query again.

9. The HR department has requested a report of all employees and their job IDs. Display the last name concatenated with the job ID (separated by a comma and space) and name the column Employee and Title.

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

11. Display all employee last names in which the third letter of the name is a.

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

13. Display the last name, job, and salary for all employees whose jobs are either those of a sales representative or of a stock clerk, and whose salaries are not equal to $2,500, $3,500, or $7,000.

14. Display the last name and department ID of all employees in departments 20 or 50 in ascending alphabetical order by name

15. The HR department needs a report that displays the last name and hire date of all employees who were hired in 1994.

provied a screen shoot