ex2-8.sql

数据库系统练习答案

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"