[solved] – Question 9946

List the team names and the total number of players from the team who played less than 20 minutes on the ground in the last two years (the current year and last year). The season attribute in the database is VARCHAR(5) to allow for sports which run multiple seasons within a calendar year, such seasons are coded as, for example: 2001S, 2001W (note that the first four characters are always the year). Name the columns as ‘TEAM NAME’ and ‘LESS THAN 20 COUNT’. Sort the output according to the ‘LESS THAN 20 COUNT’ column, teams with have the same count should be ordered by team name.

Expert Answer

---