求一个多表查询统计的sql语句,谢谢了!

[carolduan]

有如下3张表:
学生表studentTable(studentID,studentName)
课程表courseTable(courseID,courseName)
选课表scTable(courseID,studentID)
要做如下查询:
A统计每门课程名称及该课程学生数查询
B统计每个学生姓名及该学生学习课程数的查询


想不出答案,求各位大大们帮忙!不盛感激!

[jdsnhan]

select max(a.courseName),sum(studentID)
from courseTable a ,scTable b
where a.courseID = b.courseID
group by a.courseID

第二个和这个差不多。

[goldarcher2005]

A:
select a.courseName,count(studentID)
from courseTable a ,scTable b
where a.courseID = b.courseID
group by a.courseName
B:
select a.studentName,count(courseID)
from studentTable a ,scTable b
where a.studentID= b.studentID
group by a.studentName

[超叔csdn]

select a.courseName,count(studentID)
from courseTable a ,scTable b
where a.courseID = b.courseID(+)
group by a.courseName

select a.studentName,count(courseID)
from studentTable a ,scTable b
where a.studentID= b.studentID(+)
group by a.studentName
其实就是楼上的，加个左连接严密些。分给楼上吧