UPDATE SC
SET GRADE=GRADE*0.1+GRADE
WHERE SC.C#='C2';

DELETE FROM SC
WHERE SC.C# IN 
			(	SELECT C#
			    FROM C
				WHERE CNAME='PHYSICS' );

DELETE FROM S
WHERE S.S#='S8';
DELETE FROM SC
WHERE SC.S#='S8';