I have a table called avatars, it has id, series ... Now i want to count the number of avatars of each series.
I ran this code in mysql -> SELECT series, COUNT(*) as 'count' FROM avatars GROUP BY series LIMIT 0, 30
Then it showed me a table that has 2 columns (series and count), for example...