Create view failed - a column is a projected expression that is not named
This message appears when a CREATE VIEW statement includes an unnamed value expression (that is not a direct column reference) in the projection list of the defining SELECT statement.
The value expression must be given a correlation name, which will be the name of the output column when the view is queried.