Help with Google Sheets query formula to show top 10 sorted results

Super easy for someone experienced with the Google Sheets query function. I have a table of data and trying to figure out how to show the top 10 or top 20 results sorted high to low based on total of a table of data. This thread is similar to what i need done.

https://support.google.com/docs/thread/47384974/how-to-create-top-10-on-google-sheet-pivot-table?hl=en