Question

How to use SQL GROUP BY statement in MySQL

Answer 1

SELECT category, COUNT(category) AS category_count 
FROM all_info
GROUP BY category

-- run:

--  category 	category_count 
--     aaa               28
--     bbb                3

 

70+ SQL courses for beginners and professionals