Answer to Question #9946 in Databases | SQL | Oracle | MS Access for Neema

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's answer
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.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be the first!

Leave a comment

Ask Your question

New on Blog