Page 119 - IPP-12-2025

(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;

DISTINCT Acode

1001

1003

1008