SQL统计XX(班级)人数、选出课程编号不为XX(100)的学生学号

SQL统计XX(班级)人数

1、创建数据库

create database counttest1;

use counttest1;

2、建表

create table counttest(class char(1),no char(2),courseno char(3));

insert into table counttest values
('1','01','100'),
('1','02','200'),
('2','01','100'),
('3','01','100'),
('1',' ','100'),
('1',null,'200');

3、查询class的人数

select class,count(*) sums
from counttest
group by class;

4、选出课程编号不为XX的学生学号

 select no from counttest where courseno != 100;