agregate sales totals per years per customer in one transaction

i have a normal turnover table with 3 columns "customer" , "year", "amount"
(for example)

and i have the following mysql query

SELECT `customer` , SUM(`amount`) as summ FROM `customer`.`accountsales` WHERE `amount`> 0 GROUP BY `customer` ORDER BY summ DESC ;

This transaction gives me a nice Paretto table with the sales of each customer in descending order

so far so good, i want to go one step further and i want to create the following table

but i want to do it in only one transaction, because the initial table is very huge.

can someone give a hint ?

p.S. feel free to edit the title since I am not very inspired today

>Solution :

You can try to use condition aggregate function

Query 1:

SELECT `customer` , 
       SUM(`amount`) 'Sales all years',
        SUM(CASE WHEN year = 2021 THEN `amount` ELSE 0 END)  Sales2021,
        SUM(CASE WHEN year = 2020 THEN `amount` ELSE 0 END)  Sales2020,
        SUM(CASE WHEN year = 2019 THEN `amount` ELSE 0 END)  Sales2019
FROM accountsales
GROUP BY `customer`

Results:

| customer | Sales all years | Sales2021 | Sales2020 | Sales2019 |
|----------|-----------------|-----------|-----------|-----------|
|    anton |              22 |         5 |         5 |        12 |
|  felicia |               5 |         5 |         0 |         0 |
|   felipe |              12 |         0 |         0 |        12 |
|     paul |              22 |         0 |         0 |        22 |