How to get the count of each distinct value in a column? [duplicate]

October 8, 2022 by Tarik

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