create table if not exists student(  --创建数据表student
    name,
    age,
    school
)

drop table if exists student. --删除数据表student

select school, province from school  --查询学校的名称以及所在省份

select * from school  --查询所有学校的所有信息

select province,count(*) as 学校数 from school group by province  --根据省份进行分组，然后统计各个省份的高校数量

select * from school where province = "江西省"  --查询江西省的所有高校

select * from school where school_code between "10404" and "10410"  --查询院校代码在10404～10410的高校信息

select * from school where province in ("江西省","湖南省")  --查询湖南省或者江西省的高校信息

select * from school where is_985 = "是" and is_211 = "是"  --查询既是985，又是211的高校

select * from school where school like "%师范%"  --查询所有的师范类院校

select province, count(*) as 学校数 from school group by province order by 学校数 desc  --对刚才生成的各省份高校信息数进行降序排序

insert into student(name, age, school) values ("张三", 20, "江西财经大学")  --在学生表student中，插入张三对应的信息

insert into student (name, school) values ("bbb", "江西财经大学")  --在学生表student中，插入对应的信息

update student set school = "江西师范大学" where name = "张三"  --将张三的学校改为江西师范大学

delete from student where school = "江西财经大学"  --在学生表student中，将学校是江西财经大学的信息删除