Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Challenge: Employees With More Than Average Salary | Nested Subqueries
Intermediate SQL

bookChallenge: Employees With More Than Average Salary

When a subquery is written in the WHERE section, we can use the IN operator and comparison operators:

SELECT column1, ...
FROM table
WHERE column1 > (SELECT AGG(column2) FROM table)
Task

Swipe to start coding

Find employees whose salary is above the average salary of all employees using a subquery in the WHERE section.

The resulting table should have 3 columns: first_name, last_name, and salary. Then, sort the result by salary from highest to lowest using ORDER BY.

Note

This syntax can be used as a great alternative to the HAVING clause.

Brief Instructions

  • Retrieve the first_name, last_name, and salary columns from the employees table.
  • In the WHERE clause, use an inner query with the syntax salary > [inner query].
  • In the inner query, get the average value of the salary column from the employees table.
  • Sort the results by salary in descending order.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 4
single

single

Ask AI

expand

Ask AI

ChatGPT

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

close

Awesome!

Completion rate improved to 4

bookChallenge: Employees With More Than Average Salary

When a subquery is written in the WHERE section, we can use the IN operator and comparison operators:

SELECT column1, ...
FROM table
WHERE column1 > (SELECT AGG(column2) FROM table)
Task

Swipe to start coding

Find employees whose salary is above the average salary of all employees using a subquery in the WHERE section.

The resulting table should have 3 columns: first_name, last_name, and salary. Then, sort the result by salary from highest to lowest using ORDER BY.

Note

This syntax can be used as a great alternative to the HAVING clause.

Brief Instructions

  • Retrieve the first_name, last_name, and salary columns from the employees table.
  • In the WHERE clause, use an inner query with the syntax salary > [inner query].
  • In the inner query, get the average value of the salary column from the employees table.
  • Sort the results by salary in descending order.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 4
single

single

close

Awesome!

Completion rate improved to 4

bookChallenge: Employees With More Than Average Salary

Swipe to show menu

When a subquery is written in the WHERE section, we can use the IN operator and comparison operators:

SELECT column1, ...
FROM table
WHERE column1 > (SELECT AGG(column2) FROM table)
Task

Swipe to start coding

Find employees whose salary is above the average salary of all employees using a subquery in the WHERE section.

The resulting table should have 3 columns: first_name, last_name, and salary. Then, sort the result by salary from highest to lowest using ORDER BY.

Note

This syntax can be used as a great alternative to the HAVING clause.

Brief Instructions

  • Retrieve the first_name, last_name, and salary columns from the employees table.
  • In the WHERE clause, use an inner query with the syntax salary > [inner query].
  • In the inner query, get the average value of the salary column from the employees table.
  • Sort the results by salary in descending order.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

some-alt