Skip to main content
Journey Uncommon Logo
JourneyUncommon
easySQLGROUP BY and HAVINGSingle-choice MCQ

A `colors` column has values 'red', 'red', 'blue', and NULL. What does this query produce?

SELECT color, COUNT(*) FROM items GROUP BY color;