-- 题目提炼: 薪水记录 超过15条的员工
SELECT
emp_no
,COUNT(emp_no) AS t
FROM salaries
GROUP BY emp_no
HAVING t > 15
;
分组------COUNT()计算-------HAVING条件
END

-- 题目提炼: 薪水记录 超过15条的员工
SELECT
emp_no
,COUNT(emp_no) AS t
FROM salaries
GROUP BY emp_no
HAVING t > 15
;
分组------COUNT()计算-------HAVING条件
END