Código:
with t as (
select
campo, count(*) cant
from tabla
where campo in (valor1, valor2, valor3, valor4)
group by campo
)
select tabla.campo, s.cant
from t, tabla
where t.campo = tabla.campo
order by t.cant desc
Sin probarlo, diría que esto funciona :P
Saludos