Register To Attempt Complete Test
An athlectics 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 cid of the appropriate competitor.
Competitor (cid, name nationality)
Even (eid, description)
Competes (cid, eid)
Identify the result of the following SQL statement.
SELECT eid FROM Competes, Competitor
WHERE Competes. cid = Competitor, cid
AND nationality = ‘Swedish’;