You can use below query for this:
select country_name, region_name,COUNT(region_name)total
FROM samples
group by country_name, region_name
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/