COUNT in SQL

Taking a row count is really not unlike taking a sum or average in SQL.

SELECT COUNT(*) as mycount From userbase
Group By firstname