求至少有两个职工的每个仓库的平均工资
- ASELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
- BHAVING COUNT(*)>=2
- CB.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
- DGROUP BY 仓库号 HAVING COUNT(*)>=2
- EC.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
- FGROUP BY 仓库号 SET COUNT(*)>=2
- GD.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
- HGROUP BY 仓库号 WHERE COUNT(*)>=2