Answer to Question #9946 in Databases | SQL | Oracle | MS Access for Neema
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.
Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.