YouriL的博客

原创 SQL进阶练习一

SQL进阶练习一 **题目一 select s.sname from s join sc on s.son=sc.son join c on sc.sno=c.sno where c.cteacher <>"小易" select sname, avg(score) from s join sc on s.sno=sc.sno where count(case when sc.s...