How to display the number of records with different values?

Question

MySQL

I'm fixing someone else's site.
It is necessary to bring out the most popular brands, there are many of them and they are different.
The brand is stored in the option column in json format.

How to get the result in the form $brands[бренд] = количество строк;if there is no list with brands?

Answer 1

SELECT
JSON EXTRACT
GROUP BY