CREATE VIEW myview(employee, currentpay, afterraise) AS SELECT lname, payrate, payrate*1.10 FROM employee
Because payrate*1.10 is an expression, column names must be provided in the CREATE VIEW clause of the command.
