I don't understand the SQL Mission Question

Q&A DQ Courses
#1

I’m currently working on the Subqueries mission and on the fourth step the question asks:

Write a query that returns the Major and Major_category columns for the rows where:

  • Major_category is one of the 5 highest group level sums for the Total column

I don’t really understand what is being asked. Especially when it says "Major_category is one of the 5 highest group level sums for the Total column" can someone break this down for me?

#2

Hey, Cu. Since you didn’t include a link to the exact screen you’re asking about, my answer is based on what you wrote here.

Conceptually, it looks to me, like it’s asking you to group by Major_category, and then for each group to sum the Total column. This results in a table.

For the resulting table, order them (descendingly) by the sum of Total and keep only the top 5 rows.