I have a table called ads and I want to get top 4 countries that has the biggest number of ads >= 2600 in the table, for example:
| Country | Ads Number |
|
| Sweden | 5000 |
|
| India | 3000 |
|
| USA | 2800 |
|
| Germany | 2600 |
|
table Name: ads [AdsID] Primary key ,[UID] ,[Section] ,[Category] ,[Country] ,[State] ,[City] ,[AdsTit] ,[AdsDesc] ,[AdsPrice] ,[Img1] ,[Img2] ,[Img3] ,[Img4] ,[Img5] ,[Wtags] ,[AdsDate] ,[Website] ,[premium]