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

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

CREATE VIEW V3 AS select * from student where stip>900

CREATE numb_3(N, NN) AS select subj_nam, count(id_subj) from progress group by id_subj

CREATE VIEW P3 (nam, snam, n_stip) AS select stud_snam, stud_nam, stip*2 from student WHERE stip=1300