Create view column count mismatch (create: number, select number)

The SQL CREATE VIEW statement's column list does not match the number of columns in the SELECT statement's select list.

Resolution:

Correct the statement.