Page 108 - IPP-12-2024
P. 108

(b)    Display the sum of PrizeMoney for the activities played in each of the stadium separately.


















              (c)  Display  the  content  of  Activity  table  whose  ScheduleDate  is  earlier
              than01/01/2004 in ascending order of ParticipantsNum.













              (d) Display the names activity and its corresponding coach name.


















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