SELECT COUNT(DISTINCT city) FROM EMPLOYEE
How many distinct cities does the employees live in?
SELECT COUNT ( DISTINCT city ) FROM EMPLOYEE
select count ( distinct city ) from employee
How many distinct cities does the employees live in ?