How to create and refresh a Materialized view in Redshift

Syntax to create materialized view:

create materialized view mv_name as (select statement);

Syntax to refresh materialized view:

REFRESH MATERIALIZED VIEW mv_name;