SQL实战

学生表，教师表，学生选课表，题目：查询每个同学学生姓名，学号，选课数，总成绩

    做法一，

SELECT s1.学号, s1.姓名, 
(Select Count(t1.课程号) From xscj.xs_kc t1 Where t1.学号=s1.学号) 所选课程,
 (Select Sum( t2.成绩) From xscj.xs_kc  t2 Where t2.学号=s1.
 学号)  总成绩  from xscj.xsqk s1;

做法二，

 SELECT s1.学号, s1.姓名, count(t1.课程号) as 选课数 ,sum(t1.成绩) as 总成绩 
   from xscj.xsqk s1 left join xscj.xs_kc t1 
   on s1.学号=t1.学号
    group by  s1.学号 ,s1.姓名;