Untitled
user_1950367
plain_text
2 years ago
967 B
3
Indexable
# Task 3. # Write a query that returns employees from top N=2 most # expensive (salary) departments. For example: # ------------------------------------------------------- # | first_name | last_name | department_name | expenses | # ------------------------------------------------------- # | Jane | Doe | Dev | 5000.0 | # | John | Doe | Sales | 2000.0 | # | Jack | Black | Sales | 2000.0 | # ------------------------------------------------------- # # Tables # Table: employee # |employee_id | first_name | last_name | department_id| salary | # |1 | John | Doe | 1 | 1000.0 | # |2 | Jane | Doe | 2 | 5000.0 | # |3 | Jack | Black | 1 | 1000.0 | # Table: departments # | department_id | name | # | 1 | Sales | # | 2 | Dev |
Editor is loading...