Untitled

 avatar
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   |