How to get the number of duplicate items in a database?

Question

MySQL

There is a table with flowers (on the left).
How to get the number of repetitions of each color in one query?? (table on the right)

Answer 1

Something like this:

SELECT `color`, COUNT(`color`) as `count` FROM `table` GROUP BY `color`;