select date, Replace(Pagename,'bn.','.'),
count(case when charindex('bn.',Pagename,0) > 0 then 1 else null end),
count(case when charindex('bn.',Pagename,0) = 0 then 1 else null end)
FROM Pages
group by date, Replace(Pagename,'bn.','.')
This will only give you the base name without 'bn' in
Output
Date Pagename bn en
2015-06-06 home.aspx 4 5
2015-06-07 welcome.aspx 1 4
Regards
Kevin