查询借出次数超过2次的所有图书的书号和书名；

select booknumber,bookname
  from book
 where booknumber in
      (select booknumber
         from checkout
     group by booknumber
    having count(1)>2);

查询除已还的书以外，目前借了5本或以上图书的读者编号和姓名；
select readernumber,readname
  from reader
 where readernumber in
      (select readernumber
         from reader
        where datediff('day',back,getdate())>0
     group by readernumber
    having count(1)>=5);