统计只有2名以下(含2名)学生选修的课程情况,统计结果中的信息包括课程名称、开课院系和选修人数,并按选课人数排序。正确的命令是
A. SELECT课程名称,开课院系,COUNT(课程编号)AS选修人数; FROM学生成绩,课程WHERE课程.课程编号=学生成绩.课程编号; GROUP BY学生成绩.课程编号HAVING COUNT(*)<=2; ORDER BY COUNT(课程编号)
B. SELECT课程名称,开课院系,COUNT(学号)选修人数; FROM学生成绩,课程WHERE课程.课程编号=学生成绩.课程编号; GROUP BY学生成绩.学号HAVING COUNT(*)<=2; ORDER BY COUNT(学号)
C. SELECT课程名称,开课院系,COUNT(学号)AS选修人数; FROM学生成绩,课程WHERE课程.课程编号=学生成绩.课程编号; GROUP BY课程名称HAVING COUNT(学号)<=2; ORDER BY选修人数
D. SELECT课程名称,开课院系,COUNT(学号)AS选修人数; FROM学生成绩,课程HAVING COUNT(课程编号)<=2; GROUP BY课程名称 ORDER BY选修人数
What form. is most beneficial to you as a working person?
A. Hire you all through your lifetime.
B. Give you higher wages or salaries.
C. Offer you salary, bonus and retirement pension.
D. Let you become a shareholder.
有多少家企业设置了警示标志?
A. 153家
B. 60多家
C. 所有企业
D. 一家也没有
A.时期B.时间C.时刻D.时候
A. 时期
B. 时间
C. 时刻
D. 时候