What does the query return?
-- emp.dept: 'A', 'A', 'B', 'C' SELECT COUNT(DISTINCT dept) FROM emp;
- 1
- 4
- 3
- 2
COUNT(DISTINCT dept) counts unique values: A, B and C.-- emp.dept: 'A', 'A', 'B', 'C' SELECT COUNT(DISTINCT dept) FROM emp;
COUNT(DISTINCT dept) counts unique values: A, B and C.