考察分组聚合,和聚合后过滤
group by
having

select emp_no
      ,count(salary) t
from salaries
group by emp_no
having t>15