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.