How can I dynamically count unique values by color in MySQL without hardcoding each color

welcome to shbcf.ru