Notes
In Salesforce Object Query Language (SOQL), you cannot use two separate "ORDER BY" clauses within a single query. You can only specify a single "ORDER BY" clause to sort the records based on one field.
However, you can sort the results by multiple fields by specifying those fields within a single "ORDER BY" clause.
SELECT Name, CreatedDate FROM Account ORDER BY CreatedDate DESC, Name ASC