Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

• GROUP BY.
• WHERE.
• ORDER BY.
• FROM.