Learn Challenge: Non-tech Department Employees

In this chapter, you will work with the employees and department tables.

Task

Swipe to start coding

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.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 2

single

Ask AI

Ask anything or try one of the suggested questions to begin our chat

In this chapter, you will work with the employees and department tables.

Task

Swipe to start coding

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.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 2

single

Swipe to show menu

In this chapter, you will work with the employees and department tables.

Task

Swipe to start coding

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.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Challenge: Non-tech Department Employees

Brief Instructions

Solution

Awesome!

Challenge: Non-tech Department Employees

Brief Instructions

Solution

Awesome!

Challenge: Non-tech Department Employees

Brief Instructions

Solution