内容发布更新时间 : 2024/5/3 9:31:00星期一 下面是文章的全部内容请认真阅读。

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