quary6.sql

来自「数据库查询语言,便于新手的使用」· SQL 代码 · 共 8 行

SELECT information.fname as "First Name", information.lname as "Last Name", information.memno as "ID",COUNT(information.memno)
FROM (
	SELECT fname , lname, memno
	FROM member LEFT  JOIN book ON (member.memno = book.borrowermemno)
) AS information
GROUP BY information.memno,information.fname,information.lname
HAVING COUNT(information.memno) > 3
ORDER BY COUNT(information.memno)  DESC