CODE EXAMPLE FOR SQL

sql select count distinct

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