How to apply Counts from same table on 3 Coumns?

Question

Hi,

Bellow is my table and having records. I want to get the counts of Country, State and city as per given below result.

Country	State	City
India	AP	Hyderabad
India	AP	Warangal
India	Gujarat	BARODA
USA	Alaska	Phoenix
USA	Georgia	Phoenix
India	AP	Warangal

I want to get below results. I want to get County, State and City Counts as per given below.

How to get this result please give me any idea.

Country	State	City	Country Count	State Count	City Count
India	AP	Hyderabad	3	3	1
India	AP	Warangal	3	3	2
India	Gujarat	BARODA	3	1	1
USA	Alaska	Phoenix	2	1	1
USA	Georgia	Phoenix	2	1	1
India	AP	Warangal	3	3	2