A view can be created as a join on two or more tables

A view can't be created as a join on two or more tables

A view can't have an ORDER BY clause in SELECT statement

A view can't be created with a GROUP BY clause in SELECT statement