Is there an easier way of grouping with this type of query?

Select Distinct
left(TrackerFil eName,38),
(Select Count(AccountNo ) from DTVSummary where Active = 'N' and TrackerFileName = 'FC200608267912 .CompMkt_Cvs3H' ) as Not_Active,
(Select Count(AccountNo ) from DTVSummary where Active = 'Y' and TrackerFileName = 'FC200608267912 .CompMkt_Cvs3H' ) as Active,
(Select Count(AccountNo ) from DTVSummary where AttemptQty...