2020-10-14

A:select count(*) from Student where name like ‘王%’;
B:select SC.sid,Student.name from SC join Student on Student.id=SC.sid where ‘数学’>‘语文’;
C:select avg（‘数学’+‘语文’） a，SC.sid from SC group by SC.sid having a>90;

1. select count(*),avg(m.english) from mark m;
2. select c.Name,c.Address,c.Telno,m.math from cust c join mark m on c.Studentno=m.studentno where c.Studentno in (11,22,33,44,55);
3. select c.Name,m.conputer from cust c join mark m on c.Studentno=m.studentno order by m.computer desc;
   4.select c.Studentno,c.Name,sum(m.english+m.math+m.computer) s from curt c join mark m on c.Studentno=m.studentno group by c.Studentno,c.Name having s>240 order by s desc;
   …练习而已，不保证正确率