CODE EXAMPLE FOR SQL

mysql show category once count how many products

SELECT category, COUNT(*) as count FROM table GROUP BY category