queries3.sql

来自「ssd7 ex3 答案」· SQL 代码 · 共 18 行

 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(*);