【正确答案】①使用CREATE建立表,使用CHECK短语来指定列值应该满足的条件。 CREATE TABLE SC (S#char(10)PRIMARY KEY, SNAME char(20)NOT NULL, AGE int NOT NULL, SEX char(2)check(SEX in('F','M')); ② SELECT S#,SNAME FROM S WHERE AGE<17 AND SEX='F'; ③ SELECT C# FROM C WHERE NOT EXISTS (SELECT* FROM S,SC WHERE S.S#=SC.S#AND SC.C#=C.C# AND SNAME='WANG');