SQL

select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name

SQL DISTINCT with COUNT

SELECT COUNT(DISTINCT country)
FROM Customers;

sql select count distinct

select column_name, count(*) AS count FROM table_name GROUP BY column_name;