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;
- select count(*),avg(m.english) from mark m;
- 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);
- 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;
…练习而已,不保证正确率