mssql count sum

select name, COUNT(name) as count from Table
group by name
    Union all
select 'SUM' name, COUNT(name)
from Table