Зміст курсу
Розширений рівень SQL
Розширений рівень SQL
Non-tech Department Employees Challenge
In this chapter, you will work with the employees
and department
tables.
Here's how they look:
employees
:
employee_id | first_name | last_name | department | salary | hire_date |
---|---|---|---|---|---|
1 | John | Doe | Engineering | 80000.00 | 2015-03-01T00:00:00Z |
2 | Jane | Smith | Engineering | 90000.00 | 2017-08-15T00:00:00Z |
3 | Alice | Johnson | Marketing | 75000.00 | 2016-11-10T00:00:00Z |
4 | Bob | Brown | Marketing | 72000.00 | 2018-06-25T00:00:00Z |
... | ... | ... | ... | ... | ... |
100 | William | Solis | Sales | 55000.00 | 2020-05-01T00:00:00Z |
department
:
id | name | type | budget |
---|---|---|---|
1 | Engineering | tech | 1000000.00 |
2 | Marketing | non-tech | 500000.00 |
3 | Sales | manager | 750000.00 |
4 | Human Resources | non-tech | 300000.00 |
... | ... | ... | ... |
10 | Legal | non-tech | 450000.00 |
Завдання
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.
Все було зрозуміло?
Зміст курсу
Розширений рівень SQL
Розширений рівень SQL
Non-tech Department Employees Challenge
In this chapter, you will work with the employees
and department
tables.
Here's how they look:
employees
:
employee_id | first_name | last_name | department | salary | hire_date |
---|---|---|---|---|---|
1 | John | Doe | Engineering | 80000.00 | 2015-03-01T00:00:00Z |
2 | Jane | Smith | Engineering | 90000.00 | 2017-08-15T00:00:00Z |
3 | Alice | Johnson | Marketing | 75000.00 | 2016-11-10T00:00:00Z |
4 | Bob | Brown | Marketing | 72000.00 | 2018-06-25T00:00:00Z |
... | ... | ... | ... | ... | ... |
100 | William | Solis | Sales | 55000.00 | 2020-05-01T00:00:00Z |
department
:
id | name | type | budget |
---|---|---|---|
1 | Engineering | tech | 1000000.00 |
2 | Marketing | non-tech | 500000.00 |
3 | Sales | manager | 750000.00 |
4 | Human Resources | non-tech | 300000.00 |
... | ... | ... | ... |
10 | Legal | non-tech | 450000.00 |
Завдання
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.
Все було зрозуміло?