oracle sql count occurrences of value in column code example

Example: oracle sql count occurrences of value in column

SELECT t.COLUMN,
         COUNT(*) AS numInstances
    FROM YOUR_TABLE t
GROUP BY t.COLUMN