SQL: How to get the count of each distinct value in a column?

12/18/2017 - 12:21 PM

SELECT
  category,
  COUNT(*) AS `num`
FROM
  posts
GROUP BY
  category

Cacher is the code snippet organizer for pro developers