(2)SELECT Cno,COUNT(*) FROM SC GROUP BY Cno ORDER BY COUNT(*)DESC,Cno; 四、（本题12分） 4.参考答案： (I)说明：EXEC SQL BEGIN DECLARE SECTION; char title[30]; int length; char type[10]; int year; char SQLSTATE[6]; EXEC SQL END DECLARE SECTION; (2)赋值：title:=‘手机’； length:=120; type:=‘color'; year:=2004; (3)插入：EXEC SQL INSERT INTO Movie VALUES(:title,:length,:type,:year); 五、（每小题6分，共12分） 5.参考答案： (1)SELECT P.PN FROM P,P AS PX WHERE P.COLOR=PX.COLOR AND PX.PN=“TV”; (2)SELECT SN FROM S WHERE NOT EXISTS (SELECT 445(2)SELECT Cno ，COUNT( FROM SC GROUP BY Cno ORDER BY COUNT( DESC ,Cno; 四、{本题 4. (1)说明: EXEC SQL BEGIN DECLARE SECTION; char title[30] ; int length; char type[10J; lOt year; char SQLSTATE[6] ; EXEC SQL END DECLARE SECTION; (2) 值ztitlez= length: = 120; type: =‘ color ' ; year: = 2004 ; (3) EXEC SQL INSERT INTO Movie vdnr Vd va &E··-h e--.e ngb VAL UEQU 五、{每小题 6分，共 2分) 5. (1) SELECT P. PN FROM P ,P AS PX WHERE P. COLOR=PX. COLOR AND PX. PN="TV"; (2) SELECT SN FROM S WHERE NOT EXISTS (SELECT 445