SELECT TOP (100) PERCENT COUNT(id) AS Searches, UserIpAddress FROM dbo.ARA_IP_Search_24Hour_Record GROUP BY UserIpAddress HAVING (UserIpAddress = N'54.83.239.226') ORDER BY Searches DESC Rental HQ > Find a Rental Store