6.sql

ssd7数据库的联系一到练习三

select m.memno,m.fname,m.lname,count(*) AS borrowedbooks
from member m,book b
where m.memno=b.BorrowerMemNo
group by m.memno,m.fname,m.lname
having count(*)>=3
order by borrowedbooks desc;