MySQL command to count the number of entries for a group
SELECT <i>field_to_count</i>, count(id) FROM `<i>table_name</i>` group by <i>field_to_count</i>
MySQL command to count the number of entries for a group
SELECT <i>field_to_count</i>, count(id) FROM `<i>table_name</i>` group by <i>field_to_count</i>