this statment get count of all and every type
select
COUNT(*) [total No of Attend Call]
,SUM(case when ContactStatus='Successful Contact' then 1 else 0 end)[Successful Contact count]
,SUM(case when ContactStatus='Engaged' then 1 else 0 end)[Engaged count]
,SUM(case when ContactStatus='Contact Again' then 1 else 0 end)[Contact Again count]
,SUM(case when ContactStatus='Disconnected' then 1 else 0 end)[Disconnected count]
from tableName