ex2-6.sql

来自「数据库系统练习答案」· SQL 代码 · 共 9 行

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