数据库实验三

3-2

DELTE FROM  test3_03
WHERE
(sex != '男' and sex != '女' and sex IS NOT NULL)

3-3

CREATE TABLE test3_03 AS
SELECT * FROM pub.student_31；
DELETE FROM  ​test3_03
WHERE
(sex != '男' and sex != '女' and sex IS NOT NULL；

3-4

CREATE TABLE test3_04 AS
SELECT * FROM pub.student_31；
DELETE FROM test3_04 WHERE
(dname IS NULL) OR (length(dname) < 3) OR 
(length(dname) > length(trim(dname)))

3-5

CREATE TABLE test3_05
AS
SELECT * FROM pub.student_31 
DELETE FROM TEST3_05
WHERE 
(length(class ) != 4) 

3-6

DELETE FROM test3_06
WHERE
name like '% %' or length(name) < 2

3-7

CREATE TABLE test3_07
AS
SELECT * FROM pub.student_course_32
DELETE FROM test3_07
WHERE
sid not in (SELECT sid FROM pub.student)

3-8

CREATE TABLE test3_07
AS
SELECT * FROM pub.student_course_32
DELETE FROM test3_08 t3
WHERE
cid not in
(
SELECT cid FROM pub.teacher_course p WHERE
p.tid = t3.tid
)

3-9

CREATE TABLE test3_09
AS
SELECT * FROM pub.student_course_32
DELETE FROM test3_09
WHERE
score < 0 or score > 100

3-10

CREATE TABLE test3_10ASSELECT * FROM pub.student_course_32DELETE FROM test3_10WHEREsid not in (SELECT sid FROM pub.student)DELETE FROM test3_10 t3WHEREcid not in(SELECT cid FROM pub.teacher_course p WHEREp.tid = t3.tid)