queries6.sql

ssd7 ex3 答案

 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;