codice:
select idutente,
sum(if(valore='forse',1,0)) as tot_forse,
sum(if(valore='no',1,0)) as tot_no,
sum(if(valore='si',1,0)) as tot_si
from tabella
group by idutente