Skip to content
RED SAGSkills
hard20 pts · first answer countssqlnull-handlingaggregation

GROUP BY with NULL keys

t has (region, amt): (N, 1), (NULL, 2), (S, 3), (NULL, 4). How many rows does the query return, and what is the sum for the NULL region?

SELECT region, SUM(amt) FROM t GROUP BY region;
Choose one answer