Sql query for distinct count - Cling

COUNTRIES SELECT (DISTINCT Department) AS “Single Departments” FROM employees DOVE first_name = ’John'; Again, the COUNT field (DISTINCT Department) is aliased as “Unique Departments.” This is the name of the field that will be displayed in the result set. In some cases, you will need to use the GROUP BY clause with the COUNT function. ................
................