advice needed for SQL query

advice needed for SQL query

Can some one help to provide the SQL query should be used to pull out the
"columna" value which has max number "columnb" value as "Active". Means in
columnb there is a value "Active" , I want to pull the columna value which
has max of value Active n columnb.
I am looking output to be columna = M1 and Count = 4
columna columnb M1 Active M1 Active M1 Active M1 Active M2 failed M2
failed M2 failed M3 pending M3 pending M3 pending