一个已经具备运行条件，但由于没有获得CPU而不能运行的进程处于

A．SELECT学号FROM选课表WHERE COUNT(*)＞=3
B．SELECT学号FROM选课表HAVING COUNT(*)＞=3
C．SELECT学号FROM选课表GROUP BY学号HAVING COUNT(*)＞=3
D．SELECT学号FROM选课表GROUP BY学号WHERE COUNT(*)＞=3

A．SELECT S#，SNAME FROM S WHERE S#=(SELECT SS# FROM SC WHERE C#=‘C2’)
B．SELECT S#，SNAME FROM S，SCWHERE S#=SS#AND C#=‘C2’
C．SELECT S#，SNAME FROM S，SCWHERE S#=SS#AND C#=‘C2’ORDER BY S#
D．SELECT S#，SNAME FROM S WHERE S#IN (SELECT SS# FROM SC WHERE C#=‘C2’)