The SQL selects all the events which Swedish competitors have entered. The only Swedish competitor is Sven (03) who has one entry in the Competes table: (03, 02).
The SQL selects all the events which Swedish competitors have entered. The only Swedish competitor is Sven (03) who has one entry in the Competes table: (03, 02).
The SQL selects all the events which Swedish competitors have entered. The only Swedish competitor is Sven (03) who has one entry in the Competes table: (03, 02).
The SQL selects all the events which Swedish competitors have entered. The only Swedish competitor is Sven (03) who has one entry in the Competes table: (03, 02).
An athletics meeting involves several competitors who participate in a number of events. The database is intended to record who is to take part in which event and to record the outcome of each event. As results become available the winner attribute will be updated with the cid of the appropriate competitor.
Competitor(cid, name, nationality) Event(eid, description, winner) Competes(cid, eid)
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||
Identify the result of the following SQL statement:
SELECT eid FROM Competes, Competitor
WHERE Competes.cid=Competitor.cid
AND nationality = 'Swedish'
01
02
03
04
None of the above
| ||||
| ||||
|