I have a list of tags in a database.

Ex:

villan hero spiderman superman superman

I wanted to obtain a sorted list of the tag names in ascending order and the number of times the unique tag appeared in the database. I wrote this code:

Ex:

 SELECT hashtag.tag_name, 
 COUNT( * ) AS number
 FROM hashtag GROUP BY hashtag.tag_name
 ORDER BY hashtag.tag_name ASC

This yields the correct result:

• hero - 1
• spiderman - 1
• superman - 2
• villan - 1

How can I obtain the full COUNT of this entire list. The answer should be 4 in this case because there are naturally 4 rows. I can't seem to get a correct COUNT() without the statement failing. Thanks so much for the help! :)