1. CREATE TABLE SC(SNO VARCHAR2(20),CNO VARCHAR2(20),SCORE VARCHAR2(20)) 2. select s.SNO, s.SNAME from S s join SC sc on s.SNO = sc.SNO where sc.CNO IN (select c.CNO from C c, T t where sc.CNO = c.CNO and c.TNO = t.TNO and t.TNAME = '刘铭' and rownum = 1) 3. select s.SNAME,s.AGE from S s join SC sc on s.SNO = sc.SNO where sc.CNO !='C02'本回答被提问者采纳