quary8.sql

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

SELECT fname AS "FIRST NAME"
FROM member
WHERE memno IN (
	SELECT memno
	FROM member
	WHERE phonenumber LIKE '412%'
	INTERSECT
	SELECT borrowermemno
	FROM book
	WHERE callnumber IN
			(
			 SELECT callnumber
			 FROM title
			 WHERE name = 'Pitt Roads'
			)
)