Our climate scientist is interested in getting 6 locations with the highest average of measured air temperatures from the "time_series_location_temp" table. Help her write the corresponding SQL query, which should be returning the results ranked in ascending order, from highest to lower averages.