山东大学数据库上机实验2

//*****************************1***************************
CREATE TABLE test2_01 AS
SELECT  sid,
        name
FROM    pub.student
WHERE   sid NOT IN
        (
                SELECT sid FROM pub.student_course
        );
//*****************************2***************************
CREATE TABLE test2_02 AS
SELECT sid,
        name
FROM    pub.student
WHERE   sid IN
        (
                SELECT  sid
                FROM    pub.student_course
                WHERE   cid IN
                        (
                                SELECT cid FROM pub.student_course WHERE sid=200900130417
                        )
        )
//****************************3*******************
CREATE TABLE test2_03 AS
SELECT sid,
        name
FROM    pub.student
WHERE   sid IN
        (