CREATE VIEW sub_2 AS SELECT * FROM academ_success WHERE id_sub=203;

CREATE VIEW cnt_m (dat,c_mark) AS select ac_date, count(*) from academ_success group by ac_date;

CREATE VIEW st_3 (s_nm, s_fnm, st_stip) AS SELECT s_nm, s_fnm, st_stip *2 FROM students WHERE stip=1200

UPDATE exl_3 SET stip = 1500 WHERE snom=12;

DECLARE CURSOR cur_stp FOR SELECT stud_name, stud_fname, stip FROM students WHERE stip=1200;