1.select * from 入学时间 between 2000 and 2002 order by desc 2.select count(*),areaname,people from student group by areaname,people 3.select 班级,专业 from where 学生.学号=课程.学号 4.insert into 专业表 values(199,'音乐系',60)
热心网友时间:2024-10-25 19:57
把表结构给出来
热心网友时间:2024-10-25 19:54
1 select * from Class where 入学时间(time)between 2000 and 2002 order by Desc 2select 地区名,人数 from 分组统计表 group by 地区 3 4insert into 专业表 values (199,'音乐系',60)