queries6.sql

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

 SELECT fname,member4.libid
 FROM member4,read_by4
 WHERE member4.libid=read_by4.libid AND
       gender='M' AND
       join_date <'1995-10-10' AND
       timesread<2
 GROUP BY member4.fname,member4.libid
 HAVING COUNT(callnumber)<5
 ORDER BY fname;