How to create a view in Redshift database

Syntax to create a view:

create view viewname as
(select statement      
);                     
See also  How to change password of a user in Redshift database