CTEs
2 / 13
EasyOutput prediction

Multiple CTEs

Given this table (employees):

idnamedeptsalary
1AliceEng90000
2BobEng80000
3CarolHR70000

What does this query return?

WITH eng AS (
  SELECT * FROM employees WHERE dept = 'Eng'
),
top_eng AS (
  SELECT * FROM eng WHERE salary = (SELECT MAX(salary) FROM eng)
)
SELECT name FROM top_eng;

← → arrow keys to navigate

Sign in to save your progress.