CODE EXAMPLE FOR SQL

create view in mysql workbench

CREATE [OR REPLACE] VIEW [db_name.]view_name [(column_list)]
AS
  select-statement;