Query to get termID, term name and number of posts that has that term
See the example for Views Group By -- "List top 10 most frequent terms applied to a specific node type and the number of nodes for each term."