SELECT COUNT(DISTINCT city) FROM EMPLOYEE
Find the number of different cities that employees live in.
SELECT COUNT ( DISTINCT city ) FROM EMPLOYEE
select count ( distinct city ) from employee
Find the number of different cities that employees live in .