DBMS 2 (2) - c. List the names of debaters who have not won...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ID: W0094835 Name: Tejas K Patel a. Give all contest details of contests where the starting debater is a member of the “Plato” club and prevented his opponent from scoring any points. SQL:- SELECT starter, pointsStarter, ender, pointsEnder, debatedate FROM Contest WHERE pointsEnder = 0 AND starter IN (SELECT name from Debater where club = 'Plato') Relational Algebra π ender, pointsEnder, pointsStarter, starter(( σ name (club=plato) Debater) ^ pointsEnder = 0 ) Contest b. List the names of debaters won at least one contest. SQL:- SELECT name FROM Debater WHERE name IN (SELECT ender FROM Contest WHERE pointsEnder > pointsStarter)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

DBMS 2 (2) - c. List the names of debaters who have not won...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online