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;