in the INTO clause of an INSERT statement

in the GROUP BY clause of a SELECT statement

in the VALUES clause of an INSERT statement

in the ORDER BY clause of a SELECT statement