Question

SQL查询练习 access 求大神！！！

1. 检索课程名中包括“数据库”的课程详细信息，结果按学分降序排列。
2. 统计各系学生的选课人数和选课总次数（结果显示系名、选课人数和选课总次数）。





Answer 1

1. Select *from COURSE Order by CCREDIT DESC

2. Select

     b.SDEPT,

     Count(b.SNO) as Times01,

          sum(a.Times02) as Times02
          from  (Select SNO,Count(SNO) as Times02 from SC group by SNO)a

          right join  Student b
          On a.SNO=b.SNO
          group by b.SDEPT

Answer 2

先采纳吧.然后加我扣扣一生一世000五二〇0