8、对教师表,按照教师的职称(Tprot字段)进行分组,统计每个职称的教师人数,对应的SQL语句是()。

A.Select Tprot,COUNT(*) from Teacher Order by Tprot B.Select Tprot,COUNT(*) from Teacher Group by Tprot C.Select Tprot,SUM(*) from Teacher Group by Tprot D.Select Tprot,SUM(Tprot) from Teacher Group by Tprot

时间:2023-12-29 09:33:28

相似题目