codice:
select 
sum(if(presenza=0,1,0)) as assenti,
sum(if(presenza=1,1,0)) as presenti
from tabella