【名词&注释】
可靠性(reliability)、复杂度(complexity)、合理性(rationality)、不存在(there is no)、数据结构(data structure)、轻量级(lightweight)、线性表(linear list)、平均工资(average wage)、数量级(magnitude)
[单选题]求至少有两个职工的每个仓库的平均工资(average wage)
A. SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
B. HAVING COUNT(*)>=2
C. SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
D. GROUP BY 仓库号 HAVING COUNT(*)>=2
E. SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
F. GROUP BY 仓库号 SET COUNT(*)>=2
G. SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
H. GROUP BY 仓库号 WHERE COUNT(*)>=2