Beta
Table of Contents
The outline of your notebook will show up here. You can include headings in any text cell by starting a line with # , ## , ### , etc., depending on the desired title hierarchy.
Unknown integration
DataFrameavailable as
df
variable
-- Select the names, hire date and salaries of the 10 highest paid employees
SELECT DISTINCT employees.emp_no,
first_name,
last_name,
hire_date,
salary
FROM employees
JOIN salaries
on salaries.emp_no = employees.emp_no
WHERE employess.emp_no in (SELECT emp_no
FROM salaries
WHERE to_date >= CURDATE()
)
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
df
variable
SELECT emp_no
FROM salaries
WHERE to_date >= CURDATE()
ORDER
BY salary desc
LIMIT 10This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.