queries3.sql

ssd7 ex3 答案

 SELECT libid,fname
 FROM book4,member4
 WHERE book4.borrowerid=member4.libid
 GROUP BY member4.libid,member4.fname
 HAVING COUNT(*) >
 (SELECT COUNT(*)
  FROM book4)*0.05
 ORDER BY COUNT(*);