Course Content
Intermediate SQL
Intermediate SQL
Non-tech Department Employees Challenge
In this chapter, you will work with the employees
and department
tables.
Here's how they look:
employees
:
department
:
Swipe to show code editor
Let's move on to practice!
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.
Thanks for your feedback!
Non-tech Department Employees Challenge
In this chapter, you will work with the employees
and department
tables.
Here's how they look:
employees
:
department
:
Swipe to show code editor
Let's move on to practice!
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.
Thanks for your feedback!
Non-tech Department Employees Challenge
In this chapter, you will work with the employees
and department
tables.
Here's how they look:
employees
:
department
:
Swipe to show code editor
Let's move on to practice!
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.
Thanks for your feedback!
In this chapter, you will work with the employees
and department
tables.
Here's how they look:
employees
:
department
:
Swipe to show code editor
Let's move on to practice!
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.