CREATE VIEW P3 ( FAM, IM, NSTIP) AS select sfan, sima, STIP*2 from student WHERE STIP=300

CREATE VIEW NOWVIDM AS select * from VIDM

CREATE VIEW P1 (udat,col) AS select. DATA, count(*) from uspish group by DATA

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

CREATE VIEW P2 AS select * from uspish where pnom=203