This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: c. List the names of debaters who have not won a contest. SQL:-SELECT name FROM Debater WHERE name NOT IN (SELECT name FROM Debater WHERE name IN (SELECT starter FROM Contest WHERE pointsStarter > pointsEnder) d. Give the name and age of all starter debaters who have lost exactly one debate. . SQL:-Page 1 ID: W0094835 Name: Tejas K Patel SELECT name,age FROM Debater,Contest WHERE name = starter AND pointsEnder > pointsStarter GROUP BY name,age Having COUNT(*) = 1 Page 2...
View Full Document
- Spring '10
- Algebra, Relational model, debater, Tejas K Patel