数据库——​某排课系统有下面的数据表,求IT 大神解救
发布网友
发布时间：2022-05-06 12:36
共1个回答
热心网友
时间：2022-06-30 13:42
select * from class where volumn(人数) > 100;
b:
select * from student where id in (select sid from stuclass group by sid having count(*) > 2)
c:
select c.* from course as c,stuclass as s where c.gid != s.gid;
麻烦把这几个语，句的explain 贴出来，谢谢！手打，未测试，有问题再回
