In this query how to count unique values of one column
SELECT col_name, COUNT(*) AS frequency FROM tbl_name GROUP by col_name ORDER BY frequency DESC;