This is practice with the MySQL Employees DB. The diagram for it is here.
I want to know the top 10 salaries.salary, by employees.gender.
I have tried:
SELECT DISTINCT employees.emp_no, employees.first_name, employees.last_name, employees.gender, salaries.salary
FROM employees
JOIN salaries ON employees.emp_no = salaries.emp_no
ORDER BY salaries.salary DESC
LIMITFor further actions, you may consider blocking this person and/or reporting abuse
Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.
Yudhas Develop -
Yudhas Develop -
Abhay Singh Kathayat -
Abhay Singh Kathayat -
Top comments (0)