Page 109 - IPP-12-2024
P. 109

(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
   104   105   106   107   108   109   110   111   112   113   114