Insert SC select S#,’002’,(Select avg(score) from SC where C#=’002’) from Student where S# not in (Select S# from SC where C#=’002’);
