How to create a view in Redshift database

Syntax to create a view:

create view viewname as
(select statement      
);                     
See also  How to list all tables and views in Redshift