[单选题]下列SQL语句（）查询结果为所有王姓员工(姓名字段name)的信息。 A.select * from Employee where name like '王__' B.select * from Employee where name = '王%' C.select * from Employee where name like '王%' D.select * from Employee where name like '%王%'
[单选题]现有学生表student_tb，其字段有：name(学生姓名)，classid（班级编号），sex(学生性别),统计 student_tb 表中男生人数的SQL是（）。 A.select count(*) from student_tb where sex = '男'; B.select sum(*) from student_tb where sex = '男'; C.select max(*) from student_tb where sex = '男'; D.select avg(*) from student_tb where sex = '男';
[单选题]现有商铺表shop，其字段有：name(商铺名称)，classid（类别编号），address(位置),分别统计每个类别的商铺数量，可以使用的SQL是（）。 A.select classid,count(*) as num from shop group by classid; B.select classid,count(*) as num from shop group by name; C.select classid,sum(*) as num from shop group by address; D.select classid,sum(*) as num from shop group by classid;
