mysql经典笔试题

sql数据库经典笔试题

题目一

解答：

1. select avg(eglish) from mark;
2. select mark.math,cust.Name,cust.Address,cust.Telno from mark join cust on mark.studentno = cust.Studentno where cust.studentno in (11,22,33,44,55);
3. select cust.Name ,mark.computer form cust join mark on cust.Studentno = mark.studentno
   order by mark.computer desc;
4. select cust.Studentno,cust.Name,english + math + computer total
   from cust join mark on cust.Studentno = mark.studentno
   having total > 240
   order by total desc;

题目二