codice:
select acquirente,
sum(rosse)+sum(verdi)+sum(blu) as totale,
(sum(rosse)+sum(verdi)+sum(blu) ) / count(acquirente) as media,
avg(rosse) as media_rosse,avg(verdi) as media_verdi,avg(blu) as media_blu,
count(acquirente) as numero_acquisti
from acquisti
group by acquirente
order by acquirente