DBA Exercise – Aggregation

This is the last SQL training exercise of the series featuring the students business field.

As a reminder, check out the 4 exercises :

  1. Select query DBA exercise – including the context data
  2. 3 best students select statement
  3. Group By Statement exercise
  4. More about Aggregation (current page)

Context

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Want more information?

Related links will be displayed within articles for you to pick up another good spot to get more details about software development, deployment & monitoring.

Stay tuned by following us on Youtube.

%d bloggers like this: