:confused:Ordering by Ascending and Descending

Table: sports_played

parent_id    child_id   sport_code          level
1                   1         SW               Advanced
1                   1         SR                Advanced
2                   1         TN               Intermediate
2                   2         TN                 Beginner
2                   2         HK               Advanced
3                   1         SR              Intermediate
3                   1         RG              Intermediate
3                   1         BS                 Beginner
5                   1         BS               Advanced


Table: sport
sport_code  sport_name   winter    summer_sport    coach_id
  SW             Swimming     Yes          Yes                 4
  TN               Tennis        Yes          Yes                     
  RG               Rugby         Yes           No                 1
  BS             Basketball      No           Yes                 2
  HK              Hockey         No           Yes                 2
  SR              Soccer         Yes          No                  2
  SL              Sailing          No           Yes                 4

SELECT sport.sport_name, Count(sports_played.level) As SumOfLevels
          FROM sports_played RIGHT OUTER JOIN sport
                     ON sports_played.sport_code =
sport.sport_code
                     AND sport.summer_sport = ‘Yes’
                            ORDER BY sport.sport_name DESC; 


SELECT sport.sport_name, Count(sports_played.level) AS SumOfLevels
          FROM sports_played LEFT OUTER JOIN sport
                     ON sports_played.sport_code = sport.sport_code
                     AND sport.summer_sport = ‘Yes’
                            ORDER BY sports_played.level ASC;