Count the distinct no of countries from the locations table

SELECT COUNT(DISTINCT COUNTRY_ID) AS "TOTAL"

FROM locations;