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
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