A view can be created as read only.

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

A view cannot have a n ORDER BY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.