2013《数据库原理及应用》实验报告答案(5)

select rdno from jieyue where bkno in ( select bkno from book

where bkname='孙子校释' )

)

--14 统计某读者当前借阅的图书的总数及总价。

select reader.rdname,count(jieyue.bkno) bsum,sum(book.price) psum from reader,jieyue,book where

jieyue.rdno='1101'

and

jieyue.bkno=book.bkno

reader.rdno=jieyue.rdno and jieyue.Return='0'

group by reader.rdname

and