第一关
use library;
######### Begin #########
## -- 1. 内联接查询在流通总库的数据库类书的ISBN、书名、作者和出版社信息。
select Books.ISBN,bname,author,press
from BookInfo inner join Books on Books.ISBN = BookInfo.ISBN
where bname like '数据库%' and bstatus='0';
######### End ##########
第二关
use library;
######### Begin #########
#-- 2、左外联接查询分类为4的用户的借阅证号、姓名、单位、及其所借图书的编号、借阅日期,结果按照单位名称升序排序。
select Users.loanNo,lname,unitName,Loan.bookNo,Loan.borrowDate
from Users left join Loan on Users.loanNo=Loan.loanNo left join LoanHist on LoanHist.loanNo=Loan.loanNo
where classNo='4'
order by unitName ;
######### End ##########
第三关
use library;
######### Begin #########
## -- 3、 使用子查询查询与借阅证号为“S06102”的用户在同一单位的所有用户的借阅证号和姓名
select loanNo,lname
from Users
where unitName =some (select unitName from Users where loanNo='S06102');
######### End ##########