ORA-00998: Must name this expression with a column alias
CREATE TABLE ... AS SELECT and CREATE VIEW need a name for every expression that is not a plain column.
On the exam
This error belongs to the topic Tables and constraints of exam 1Z0-071.
In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.