Page 118 - PYTHON-12

(e) Give the output of the following queries:

(i) SELECT COUNT(DISTINCT ParticipantsNum) FROM Activity;

COUNT(DISTINCT ParticipantsNum)

3

(ii) SELECT Max(ScheduleDate), MIN(ScheduleDate) FROM Activity;

Max(ScheduleDate) Min(ScheduleDate)

‘2004-03-19’ ‘2003-12-12’

(iii) SELECT COUNT(*) FROM Coach;

COUNT(*)

4

(iv) SELECT Name, Activityname FROM activity A, COACH C WHERE

A.Acode = C.Acode AND A.ParticipantsNum =10;

Name ActivityName

Ravinder Discuss Throw

(v) SELECT DISTINCT Acode FROM Coach;

Acode

1001

1003

1008