Refer to HR schema to answer the questions 1. Write SQL query that displays the
Question:
Refer to HR schema to answer the questions
1. Write SQL query that displays the department name, location ID, name, job title, and salary of those employees who work in Toronto
2. Write SQL query that shows the name, location, and number of employees for each department. Make sure that the report also includes departments without employees.
3. Write SQL query that displays the jobs that are found in the Administration and Executive departments. Also display the number of employees for these jobs. Show the job with the highest number of employees first.
4. Write SQL query that display all employees who have managers with a salary higher than $15,000. Show the following data: employee name, manager name, manager salary, and job title of the manager
5. Write SQL Query that display department id and department name that employs fewer than five employees
6. Write SQL Query that display department id and department name that has the highest number of employees
7. Write SQL Query that display department id and department name that has the lowest number of employees
8. Write SQL query that displays the employee number, last name, salary, department number, and the average salary in their department for all employees.