–任务1:查询计算机类的图书信息
USE library
GO
SELECT *
FROM Books
WHERE EXISTS (SELECT *
FROM BookCategory
WHERE Name='计算机' AND BookCategory.categoryid=Books.CategoryId)
–任务2:查询北京大学出版社月份出版的图书、
USE library
GO
SELECT *
FROM Books
WHERE EXISTS (SELECT *
FROM Publishers
WHERE PName='北京大学出版社') AND MONTH(PubDate)=5
–3.查询北京大学出版社1月份出版的图书
SELECT *
FROM Books
WHERE PubId=(SELECT PID
FROM Publishers
WHERE PName='北京大学出版社') AND MONTH(PubDate)=1
SELECT *
FROM Books,Publishers
WHERE Books.PubId=Publishers.PID AND PName='北京大学出版社' AND MONTH(PubDate)=1
SELECT *
FROM Books INNER JOIN Publishers
ON Books.PubId=Publishers.PID
WHERE PName='北京大学出版社' AND MONTH(PubDate)=1