When you code a SELECT statement, you must code the four main clauses in the following order

a$.$SELECT, ORDER BY$,$ FROM, WHERE

b$.$SELECT, FROM, WHERE, ORDER BY

c$.$SELECT, WHERE, ORDER BY$,$ FROM

d$.$SELECT, FROM, ORDER BY$,$ WHERE