When using qualified field names, statements can only contain a maximum of one ORDER BY clause and one GROUP BY clause. When ...

When using qualified field names, statements can only contain a maximum of one ORDER BY clause and one GROUP BY clause. When using unqualified field names, statements can either contain multiple ORDER BY clauses or multiple GROUP BY clauses.