Select Top 1000000 tblAWSInstance.Region, Count(tblAWSInstance.Region) As #OfInstances From tblAWSInstance Group By tblAWSInstance.Region Order By #OfInstances Desc