The following SQL statement selects only the DISTINCT values from the "Country" column in the "Customers" table:
SELECT DISTINCT Country FROM Customers;
The following SQL statement counts and returns the number of different (distinct) countries in the "Customers" table:
SELECT COUNT(DISTINCT Country) FROM Customers;
Practice Excercise Practice now