b. 找出借书超过5本的读者,输出借书卡号及所借图书册数
select CNO,count(BNO) as 借书数量from BORROW group by CNO having count(BNO)>3
找出借书超过5本的读者,输出借书卡号及所借图书册数——数据库
最新推荐文章于 2023-08-02 16:47:32 发布
b. 找出借书超过5本的读者,输出借书卡号及所借图书册数
select CNO,count(BNO) as 借书数量from BORROW group by CNO having count(BNO)>3