Qualified field names are required to use an ORDER BY and GROUP BY clause in the same SELECT statement. When using qualified ...

Qualified field names are required to use an ORDER BY and GROUP BY clause in the same SELECT statement. When using qualified field names, SELECT statements can only contain a maximum of one ORDER BY clause and one GROUP BY clause. When using unqualified field names, SELECT statements can either contain multiple ORDER BY clauses or multiple GROUP BY clauses.