SQL statement ordering

Recently, I’ve got a small task on creating a SQL enquiry statement. As a beginner, it’s still a easy thing to complete a statement, but it returns a error to me. I asked google about the error, after a while I understand the reason about the error message.

It has a style to complete a SQL statement, ORDER BY ***MUST*** be the last key, that is:

SELECT … GROUP BY <FIELD NAME> ORDER BY <FIELD NAME>

Please leave your comment on the topic