有关系模型 Students(学号,姓名,性别,出生年月)，要统计学生的人数和平均年龄应使用的语句是
- A.SELECT COUNT() AS 人数,AVG(YEAR(出生年月)) AS 平均年龄 FROM Students;
- B.SELECT COUNT(*) AS 人数,AVG(YEAR(出生年月)) AS 平均年龄 FROM Students;
- C.SELECT COUNT(*) AS 人数,AVG(YEAR(DATE())-YEAR(出生年月)) AS 平均年龄 FROM Students;
- D.SELECT COUNT() AS 人数,AVG(YEAR(DATE())-YEAR(出生年月)) AS 平均年龄 FROM Students;
热度🔥2,760
参考答案：C
解析：打开微信小程序查看本题解析
扫码免费计算机二级刷题
2024年计算机等级考试题库
