編程要求

數據庫中已經存在三個基礎表： student ( num integer,
name char(20), age integer, level integer, dept char(20) );

course ( id integer,
name char(20)

);

sel_course ( studentid integer,
courseid integer, score integer

);

創建存儲過程，并調用； 1）創建存儲過程proc01，在存儲過程中創建一張名為tmp的表(如果該表已經存在，應該先將其刪除)，然后把計算機學院(student.dept = 'cs')學生的學號、姓名及選修的課程名稱插入到tmp表中； 2）調用存儲過程proc01；

 --cstmpdrop procedureif exists proc01;CREATE PROCEDURE proc01()ASBEGINdrop tableif exists tmp;CREATE TABLE tmp(num integer,name char(20),course char(20));insert into tmp SELECT num, stu.name as name, c.name as courseFROM student stu, course c, sel_course swhere stu.num = s.studentid and c.id = s.courseid and stu.dept = 'cs'order by num, course;END/CALL proc01();

?

?