CREATE OR REPLACE VIEW view_name AS SELECT colA, colB FROM my_table WHERE colC = 'OK';
CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition;