Challenge: Non-tech Department Employees

Your task is to retrieve the first name, last name, and salary of those employees who work in non-technical departments.

To do this, use an inner query where you write the filtering using a WHERE clause.

You also need to sort the results by salary, from highest to lowest. Use the ORDER BY clause to accomplish this subtask.

Brief Instructions

• Retrieve the first_name, last_name, and salary columns from the employees table.
• In the WHERE clause, use a nested query with the syntax WHERE department IN.
• In the nested query, select the name column from the department table.
• In the nested query, use the WHERE clause to set type = 'non-tech'.
• Sort the results by salary in descending order.