Database/SQL Question HELP ASAP!

Question

1. Use HR Database
2. Write the SQL in Transact SQL

Question: 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.

Answer 1

Take a look at the SQL (Between) and (Not In) operators. I would have to see the actual table structure to offer a more specific example.

Answer 2

Hi Clarissa!

I suggest looking up SQL syntax on the Microsoft documentation website for more examples and explanations.

SELECT name_of_employee_column FROM name_of_table WHERE salary < min_salary OR salary > max_salary;