How to create a view in Redshift database

Syntax to create a view:

create view viewname as
(select statement      
);                     
See also  How to copy files from one S3 bucket to another using wildcard