NEED HELP ASAP!!!

Question

1. Use HR database for this assignment.
2. Number each of the statements

Write SQL statement:

1. Return all the country names and the name of their Regions.

2. Return the name of the manager of Finance Department.

3. Return the name of the employees who manage more than 3 employees.

4. Return the employee that have salary that is not in the range between the minimum salary and maximum salary of their job. For example, you need to return Adam's if their salary is 6000 and they work a job that has Min_salary 7000 and Max_salary. 10000.

5. Return all the locations that are in countries with multiple locations. For example, if Canada has 2 locations, then I need to return these 2 locations while if Sweden has only 1 location then you do not need to return that location.

*NOTE*

1. show all the codes for each questions.
2. Write the SQL in Transact SQL

Answer 1

I can help with this. But I need to see the database tables so that I can write the select statements. Also, none of your select statements need to be in transactions as they only select data.