hard20 pts · first answer countssqlnull-handlingaggregation
GROUP BY with NULL cities
The city column has: Dubai, Dubai, Abu Dhabi, NULL, NULL, Sharjah. How many rows does this query return?
SELECT city, COUNT(*) FROM customers GROUP BY city;
The city column has: Dubai, Dubai, Abu Dhabi, NULL, NULL, Sharjah. How many rows does this query return?
SELECT city, COUNT(*) FROM customers GROUP BY city;