Desafio para os Funcionários do Departamento Não-Técnico
In this chapter, you will work with the employees and department tables.
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, andsalarycolumns from theemployeestable. - In the
WHEREclause, use a nested query with the syntaxWHERE department IN. - In the nested query, select the
namecolumn from thedepartmenttable. - In the nested query, use the
WHEREclause to settype = 'non-tech'. - Sort the results by
salaryin descending order.
Solução
Obrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
What are the structures of the `employees` and `department` tables?
Can you provide some sample data from these tables?
What kind of tasks will we perform with these tables?
Awesome!
Completion rate improved to 4Desafio para os Funcionários do Departamento Não-Técnico
Deslize para mostrar o menu
In this chapter, you will work with the employees and department tables.
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, andsalarycolumns from theemployeestable. - In the
WHEREclause, use a nested query with the syntaxWHERE department IN. - In the nested query, select the
namecolumn from thedepartmenttable. - In the nested query, use the
WHEREclause to settype = 'non-tech'. - Sort the results by
salaryin descending order.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
