Aggregate Functions with SQL: using MAX w text

Screen Link:
https://app.dataquest.io/c/106/m/587/aggregate-functions-with-sql/5/first-and-last-values-in-a-text-column

My Code:

SELECT MAX(billing_country) as last_billing_country FROM invoice;

the answer was United Kingdom, but why wasnt it USA as S comes after n in an alphabetical sort OR is it the case that matters here? IF so that should be noted in the lesson that regardless of actual alphabetical order, UPPER case letters come before all lower case letters in the aggregate function.

It does. Try running SELECT MAX('A', 'a', 'b'), MAX('n', 'S');, for instance.