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: 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
This note was uploaded on 04/27/2010 for the course IT csc3400 taught by Professor Tejas during the Spring '10 term at South University Online.
- Spring '10