ex2-6.sql

数据库系统练习答案

select "memno","lname","fname","count"
from "member",(select "borrowermemno",Count("book_id") AS "count"
from "book"
GROUP BY "borrowermemno"
HAVING COUNT(*) > 3) as "reslut"
where "memno" = "borrowermemno"
ORDER BY "count" DESC