1- every employee’s salary lies within a job grade. Use your HR ERD to show the employee ID, first and last names, salary, job name, and job grade
2- displaying employees and their managers, along with the department names in which they belong. Display the employee ID, first and last name, manager ID and department name. The output must be arranged so that departments are shown together before another one is displayed.
3- Write suitable SQL statement to show this scenario: The HR department needs you to produce a report on job grades and salaries. Write a query that will display the names, job name, department name, salary, and grade for all employees.
4- subquery that reports the last name, department ID, and job ID of all employees whose department location ID is 1700 or 1800.