single
Using Inner Subqueries in the FROM Section
メニューを表示するにはスワイプしてください
An inner subquery creates a table with which we then perform operations in the outer query.
From this, we can conclude that we can also use an inner query within the FROM section to select something from this table.
Let's consider an example where we need to work with employees whose salary is above a certain value. But instead of a WHERE clause, we will use an inner query:
123456SELECT * FROM ( SELECT * From employees WHERE salary >= 70000 ) AS high_salary_employees
We've created a new table using an inner subquery with which we can work and gather information.
Notice that for such a table, it's essential to provide an alias.
When might this be useful?
Such a query is highly readable; sometimes, it can replace a WHERE clause.
Additionally, if you need to work not with the entire table but only with a filtered part, an inner subquery within the FROM section can be extremely handy.
スワイプしてコーディングを開始
Your task is to retrieve the average budget (budget column) for all managerial departments from the department table. Use an inner subquery in the FROM section to filter only the managerial type of department. Also, use the alias manager_departments for this table so the task is checked correctly.
The response should have only one column, average_budget. This is an alias for the aggregate function AVG().
This task could also be done using a WHERE clause, but we use a nested query here to practice this syntax, which will be useful for solving more complex problems in the future.
Brief Instructions
- Retrieve the average value of the
budgetcolumn. - Assign the alias
average_budgetto that column. - In the
FROMclause, you need to write a nested query. - In the nested query, select all columns from the
departmenttable. - In the nested query, use the
WHEREclause with the conditiontype = 'manager'. - Assign the alias
manager_departmentsto the nested query.
解答
実践的な練習のためにデスクトップに切り替える下記のオプションのいずれかを利用して、現在の場所から続行するフィードバックありがとうございます！
single
AIに質問する
AIに質問する
何でも質問するか、提案された質問の1つを試してチャットを始めてください
