For employees in department 5, list every ordered pair emp_a, emp_b (first names, a ≠ b) with diff = a's salary − b's salary, only where diff is positive.
Tables
departments
dept_idinteger
dept_namevarchar
locationvarchar
emp_projects
emp_idinteger
project_idinteger
rolevarchar
hours_per_weekinteger
employees
emp_idinteger
first_namevarchar
last_namevarchar
emailvarchar
dept_idinteger
manager_idinteger
job_titlevarchar
salaryinteger
hire_datedate
cityvarchar
gendervarchar
projects
project_idinteger
project_namevarchar
dept_idinteger
budgetinteger
start_datedate
end_datedate
Expected output
2 rows with columns emp_a, emp_b, diff
Hints(0/2)
Solution
Unlocks after you solve it or after 3 submissions
SQL (DuckDB)
Ctrl + Enter to runLog in to save progress and earn XP