(1)查询员工工资级别
SELECT
salary,
grade_level
FROM employees e
INNER
JOIN job_grades g
ON e.`salary` BETWEEN g.`lowest_sal` AND g.`highest_sal`;
(2)根据工资级别查询,查询人员个数大于20的数据,并且按工资级别降序
SELECT
COUNT(*),
grade_level
FROM employees e
INNER
JOIN job_grades g
ON e.`salary` BETWEEN g.`lowest_sal` AND g.`highest_sal`
GROUP BY
grade_level
HAVING
COUNT(*)>20
ORDER BY
grade_level DESC;