CREATE VIEW PR1 AS select id_stud, stud_sname, stud_name from student where stip<>NULL

CREATE VIEW P2 AS select * from progress where id_subj=203

CREATE VIEW V_1 AS select * from student where stip>600

CREATE VIEW V_2 AS select id_stud, stud_sname from student where stip=600 WITH CHECK OPTION

CREATE VIEW P1 (p_dat, numb) AS select DATA, count(*) from progress group by p_date