What request to create a table with the number of records containing the same field value?

Question

MySQL

For example I have such table

I want to receive such

To learn what sets exist.
And it would be even better to get such information, then it will be generally gorgeous

Answer 1

1) 2) Where num is the set number, table is your table