FROM SP WHERE PNO=“P2” AND SNO=S.SNO); 六、（每小题6分，共12分) 6.参考答案： (1)CREATE TABLE Movie year INT CHECK (year>=1895), ）； (2)CREATE TABLE Movie length INT CHECK (length>=60 AND length<=240), ) 446FROM SP WHERE PNO="P2" AND SNO=S. SNO); 六、{每小题 6. (1) CREATE TABLE Movie ( • • • year INT CHECK (year>=1895) , • • • ) ; (2)CREATE TABLE Movie ( • • • length INT CHECK Clength> = 60 AND length<=240) , • • • 446