Skip to content
# Add your Python code here!
Spinner
DataFrameas
df
variable
-- Select the names and most recent salaries of all current employees
SELECT first_name,
        last_name,
        hire_date,
        salary
FROM employees
  INNER JOIN salaries USING(emp_no)
WHERE to_date = (SELECT MAX(to_date) FROM salaries)
ORDER BY emp_no
LIMIT 5