easy5 pts · first answer countssqlaggregation
COUNT(DISTINCT) with NULLs
The customers table has these city values: Dubai, Dubai, Abu Dhabi, NULL, Sharjah. What does this query return?
SELECT COUNT(DISTINCT city) FROM customers;
The customers table has these city values: Dubai, Dubai, Abu Dhabi, NULL, Sharjah. What does this query return?
SELECT COUNT(DISTINCT city) FROM customers;