I figured it out. Kind of embarrassed at how easy it was. Except for ordering by top ten here is the code I came up with. If you've got a better way let me know. Thanks.
Select URI, count(uri) as total
WHERE uri LIKE '%.com/' or uri LIKE '%.%htm%'
Group by URI
Order By Total DESC