SQL - Count Total Records Containing Specific Values In A Column

SELECT SUM(CASE ColumnName WHEN 'DENIED' THEN 1 ELSE 0 END) AS DENIED,

       COUNT(CASE ColumnName WHEN 'AUTHORIZED' THEN 1 ELSE 0 END) AS AUTHORIZED

FROM TableName

Test it.....