You cannot create a view which is self-referenced.

The view definition's FROM clause includes the name of this view.  Remove the view name from the FROM clause.