1.Select Title.Name,Title.Year
From Title,Author
Where Title.CallNumber = Author.CallNumber And Author.Lname = 'Churchill'
2.Select Title.Name
From Title,Book,Member
Where Member.MemNo = Book.BorrowerMemNo And
Book.CallNumber = Title.CallNumber And
(Member.Fname = 'Susan' Or Member.Fname = 'John')
3.Select Member.MemNo,Member.Fname,Member.Lname
From Member,Book,Title
Where (Member.MemNo = Book.BorrowerMemNo And Book.CallNumber = Title.CallNumber And Title.Name = 'Iliad') Intersect
Select Member.MemNo,Member.Fname,Member.Lname
From Member,Book,Title
Where (Member.MemNo = Book.BorrowerMemNo And Book.CallNumber = Title.CallNumber And Title.Name = 'Odyssey')
4.Select Member.MemNo,Member.Fname,Member.Lname
From Member,Author,Title,Book
Where Member.MemNo = Book.BorrowerMemNo And
Book.CallNumber = Title.CallNumber And
Author.CallNumber = Title.CallNumber
Group by Member.MemNo,Member.Fname,Member.Lname
Having Count(distinct Book.CallNumber) = (Select Count(Author.CallNumber) From Author Where Author.Lname = 'Collins')
5.Select Member.PhoneNumber
From Member,Book,Author,Title
where Member.MemNo = Book.BorrowerMemNo And
Book.CallNumber = Title.CallNumber And
Title.CallNumber = Author.CallNumber And
Author.Lname = 'Tanenbaum'
6.Select Member.MemNo,Member.Fname,Member.Lname,Count(Book.CallNumber)
From Member,Book
Where Member.MemNo = Book.BorrowerMemNo
Group by Member.MemNo,Member.Fname,Member.Lname
Having Count(Book.CallNumber)>3
Order by Count(Book.CallNumber) Desc
7.Select Member.MemNo,Member.Fname,Member.Lname
From Member
Except
Select Member.MemNo,Member.Fname,Member.Lname
From Member,Book
Where Member.MemNo = Book.BorrowerMemno
8.(Select Member.MemNo,Member.Fname,Member.Lname
From Member
Where Member.PhoneNumber like '412%')
Intersect
((Select Member.MemNo,Member.Fname,Member.Lname
From Member,Book,Title)
Except
(Select Member.MemNo,Member.Fname,Member.Lname
From Member,Book,Title
Where Member.MemNo = Book.BorrowerMemNo And
Book.CallNumber = Title.CallNumber And
Title.Name = 'Pitt Roads'
Order by Member.Fname))
SSD7 Exercise2
5星 · 超过95%的资源 需积分: 10 178 浏览量
2010-12-01
22:18:19
上传
评论
收藏 17KB RAR 举报 
Exercise 2.rar （3个子文件） 
Exercise 2 
exec2.doc 64KB
table.sql 6KB
exercise2.txt 2KB资源评论
那莫名2013-11-03还不错，挺有帮助的。
晓_晨DEV2013-11-05有些帮助，总体来说
