LECT DISTINCT SNO FROM SC WHERE SNO NOT IN ( SELECT DISTINCT SNO FROM SC WHERE CNO='003')INSERT SC SELECT SNO, '002', (SELECT AVG(SCORE) FROM SC WHERE CNO = '002' GROUP BY CNO)FROM StudentWHERE SNO NOT IN (SELECT DISTINCT SNO FROM SC WHERE CNO = '003');