ex2-8.sql

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

select "fname"
from "member"
where ("memno" NOT IN (select "borrowermemno"
		      from "book" NATURAL JOIN "title"
		      where "name" = 'Pitt Roads')) AND "phonenumber" LIKE '412-%'
ORDER BY "fname"