declare @t table (id int, Network varchar(10))
insert into @t
select 1,'ESPN' union all
select 1,'FOX' union all
select 2,'ABC' union all
select 3,'FOX' union all
select 4,'ESPN' union all
select 4,'ABC' union all
select 4,'FOX' union all
select 5,'ABC' union all
select 5,'ESPN' union all
select 6,'FOX' union all
select 6,'ABC' union all
select 7,'ABC1' union all
select 7,'FOX1' union all
select 8,'ABC1' union all
select 8,'FOX1' 


--select * from @t

Select sum(Num) as NumInstances, Networks from (
select count(distinct a.ID) Num, a.id,
	Stuff(
		(select ',' + Network
		   from @t	b
		  where a.ID = b.ID
			for XML  path ('')
		)
	, 1, 1, '') Networks
from @t a	
group by a.ID) v group by Networks