第一关
use library;
######### Begin #########
## -- 4、使用子查询查询所有借书预约成功的用户的姓名和E_mail,以便通知他们
select lname,email
from Users
where loanNo =some(select loanNo from Reservation where rstatus='T');
######### End ##########
第二关
use library;
######### Begin #########
#-- 5、 使用子查询查询类别为“教师”的用户的借书情况
select bookNo,loanNo,borrowDate
from Loan
where loanNo =some (select loanNo from Users where unitName like '%学院');
######### End ##########
第三关
use library;
######### Begin #########
## 6、计算相关子查询查询借阅数量大于2本的用户的借阅证号、姓名、单位
select loanNo,lname,unitName
from Users
where loanNO =some(select loanNo from Loan group by loanNo having count(bookNo)>2);
######### End ##########