This is the last SQL training exercise of the series featuring the students business field.
As a reminder, check out the 4 exercises :
- Select query DBA exercise – including the context data
- 3 best students select statement
- Group By Statement exercise
- More about Aggregation (current page)
As usual load the context data provided on the 1st page.
Your SQL Job
Print out the average score, maximum score and minimum score for each student and order the rows from the top average score down to the last.
Of course try to optimize the query, you may alter the schema for better data indexing.
Note : Take care about the coefficients