select S# from SC where C# in (select C# from SC where S#=’1002’) group by S# having count()=(select count() from SC where S#=’1002’);
