SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)ASC
C.
SEIECT部门名,COINT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号: GROUP BY 部门名HAVING COUNT(*)>=10; ORDER BY COUNT(职工号)DESC C.SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUPBY部门名HAVING COUNT(*)>=10; ORDER BY 职工人数ASC.
D.
SELECT部门名,COUNT(职工号)AS职工人数; FROM部门,职工WHERE部门.部门号=职工.部门号; GROUP BY部门名HAVING COUNT(*)>=10; ORDER BY职工人数DESC