Now you get a multi-row result set, each row relating to a unique value (red, blue, and green), and a corresponding count of the occurrences of that value in the table.
You can look for license plates from different states, try to find the alphabet on the license plates, or count the number of red (or white or green) cars you see.