SELECT
'A=1' as chi, count(*) as alfa from PROVA where A = 1
UNION
'B=2' as chi, count(*) as alfa from PROVA where B = 2
UNION
'C=1' as chi, count(*) as alfa from PROVA where C = 1

Sarebbe stato meglio conoscere lo scopo, non il tuo tentativo...