Skip to content
RED SAGSkills
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;
Choose one answer