Skip to main content
Journey Uncommon Logo
JourneyUncommon
easySQLaggregate functionsSingle-choice MCQ

A `payments` table has a `method` column with values 'card', 'card', NULL, 'cash', NULL. How many groups does `SELECT method, COUNT(*) FROM payments GROUP BY method` produce?

SELECT method, COUNT(*) FROM payments GROUP BY method;