SELECT COUNT (DISTINCT column-name) FROM table-name
SELECT COUNT(DISTINCT country) FROM Customers;
select column_name, count(*) AS count FROM table_name GROUP BY column_name;