6.sql

来自「ssd7的练习1」· SQL 代码 · 共 6 行

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;