This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: FROM League L, Coach C, Person P, Team T WHERE T.league=L.id and C.team=T.title and C.coach=P.id and P.name='George' 3. SELECT L.name, T.title, H.coach=C.coach FROM Person P, League L, HeadCoach H, Team T, Coach C WHERE T.league=L.id and C.team=T.title and H.team=T.title and C.coach=P.i and P.name='George' 4. SELECT P.nickname, P.name FROM Team T, League L, Person P WHERE T.league=L.id and P.member=T.title and P.birthdate <= ALL ( SELECT B.birthdate FROM Person B WHERE B.member=T.title) 5. INSERT into League(id, name, level) values (42, 'Far West', 'A') 6. DELETE from League WHERE name='Far West'...
View Full Document
This note was uploaded on 04/08/2008 for the course CS 430 taught by Professor Baclawski during the Spring '08 term at Northeastern.
- Spring '08