1. 分析

分组，组内计数 count(emp_no) As t > 15

2. 代码

SELECT emp_no, COUNT(emp_no) AS t
FROM salaries
GROUP BY emp_no HAVING t > 15;