Which two statements are true regarding the ORDER BY clause? (Choose two.)
A.
It is executed first in the query execution.
B.
It must be the last clause in the SELECT statement.
C.
It cannot be used in a SELECT statement containing a HAVING clause.
D.
You cannot specify a column name followed by an expression in this clause.
E.
You can specify a combination of numeric positions and column names in this clause.
ORDER BY
CAST(SUBSTRING(issue, 1, 4) AS INT) DESC, — Year
E is right