Query multipla SQL con group by

[nicola75ss]

select
sum(if(estero=0,prezzo_vendita,0)) as tot_zero, 
sum(if(estero=1,prezzo_vendita,0)) as tot_uno,
data_vendita
from tabella
group by data_vendita