quary1.sql

数据库查询语言,便于新手的使用

SELECT name as "TITLE", year as "YEAR"
FROM title
WHERE callnumber IN
		(
		 SELECT callnumber
		 FROM author
		 WHERE lname = 'Churchill'
		);