SELECT emp_no,count(emp_no) as t FROM salaries GROUP by emp_no having t >15

先使用select查出领导的emp_no,再使用not in select出不在领导范围内的emp_no