If that is 2 different fields in your table then
SELECT Browser, Count(ip) AS IpCount FROM [YourTable]
GROUP BY Browser;
if that is single field then
create table browsers(name varchar(255));
insert into Browsers(name) values('chrome23 127.1.1.2'), ('chrome24 127.1.1.2'), ('chrome25 127.1.1.2'), ('firefox3 127.1.1.2'), ('firefox18 127.1.1.2');
select * from Browsers;
select BrowserName, Count(*) as Total from(
select SubString(name, 0, patindex('%[0-9]%', name)) as browserName, name from browsers
) as b
Group By BrowserName