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

没什么好说的，分组后筛选一下就行