SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tmp_creances_clients
( annee            integer
, montant_facture  real
);
✓
insert into tmp_creances_clients (annee, montant_facture) values
(2022, 7654.82),
(2021, 1518.95),
(2020, 18218.39),
(2019, 165744.34),
(2018, 46991.41),
(2017, 76701.13),
(2016, 447148.53),
(2015, 17713.54),
(2014, 17713.54),
(2000, 159766.95),
(1999, 6558.68),
(1998, 1031.14);
✓
with cte_exercice (exercice, montant_facture) as
(
select max(annee, max(annee) over() -4)
     , montant_facture
  from tmp_creances_clients
)
  select exercice
       , round(sum(montant_facture), 2) as montant_an
       , round(100 * sum(montant_facture) / sum(sum(montant_facture)) over(), 2) as taux
    from cte_exercice
group by exercice
order by exercice desc;


exercice
montant_an
taux


2022
7654.82
0.79

2021
1518.95
0.16

2020
18218.39
1.88

2019
165744.34
17.14

2018
773624.92
80.02

exercice	montant_an	taux
2022	7654.82	0.79
2021	1518.95	0.16
2020	18218.39	1.88
2019	165744.34	17.14
2018	773624.92	80.02