Count Unique Values of one Column

SELECT col_name, COUNT(*) AS frequency 

FROM tbl_name

GROUP by col_name

ORDER BY frequency DESC;