错误sql select avg(scode) from user where avg(scode) > 20 group by(userId); 解决办法 使用having判断,例子如下: select avg(scode) from user group by userId having avg(scode) > 20;