CODE EXAMPLE FOR SQL

mariadb create view

create [or replace] 
view [if not exists] view_name[(column_list)]
as 
select-statement;