SQL查询列出每个班的班号和总人数

select Class.class_name,count(Student.class_id)
from Student,Class
where Student.class_id = Class.class_id
group by Student.class_id
展开阅读全文

没有更多推荐了,返回首页