SELECT @total_r := sum(nb_redevables) FROM isf;
SELECT @total_i := sum(nb_redevables * impot) FROM isf;
select region,
dpt,
FORMAT(sum(nb_redevables),'de_DE') as total_redevables,
round(sum(nb_redevables) / @total_r * 100, 2) as redevables_pour_cent,
FORMAT(sum(nb_redevables * impot),'de_DE') as total_impot,
round(sum(nb_redevables * impot) / @total_i * 100, 2) as impot_pour_cent
from isf
group by region, dpt
order by redevables_pour_cent desc, impot_pour_cent desc;
Sans aucun filtre et avec les données pas seulement en pourcentage :
REGION / DPT / nb_redevables_isf / pct_repart_geo_redevables_isf / isf_percue / pct_repart_geo_isf_percueILE-DE-FRANCE PARIS 65,004 33.70 1,108,882,949 43.74
ILE-DE-FRANCE HAUTS-DE-SEINE 25,401 13.17 368,037,171 14.52
PROVENCE-ALPES-COTE D'AZUR ALPES-MARITIMES 8,478 4.39 103,377,012 4.08
ILE-DE-FRANCE VAL-DE-MARNE 8,099 4.20 79,892,689 3.15
ILE-DE-FRANCE YVELINES 8,015 4.15 85,083,902 3.36
PROVENCE-ALPES-COTE D'AZUR BOUCHES-DU-RHONE 7,255 3.76 76,969,033 3.04
AUVERGNE-RHONE-ALPES RHONE 7,103 3.68 71,706,551 2.83
NOUVELLE-AQUITAINE GIRONDE 4,865 2.52 50,005,171 1.97
LES-HAUTS-DE-FRANCE NORD 4,280 2.22 52,333,767 2.06
OCCITANIE HAUTE-GARONNE 3,394 1.76 32,503,699 1.28
PROVENCE-ALPES-COTE D'AZUR VAR 3,314 1.72 29,282,830 1.15
PAYS DE LA LOIRE LOIRE-ATLANTIQUE 2,992 1.55 29,801,378 1.18
GRAND-EST BAS-RHIN 2,197 1.14 27,756,556 1.09
OCCITANIE HERAULT 2,050 1.06 18,589,933 0.73
ILE-DE-FRANCE ESSONNE 2,034 1.05 17,986,723 0.71
ILE-DE-FRANCE SEINE-SAINT-DENIS 1,945 1.01 18,470,196 0.73
BRETAGNE ILLE-ET-VILAINE 1,836 0.95 19,328,874 0.76
NOUVELLE-AQUITAINE PYRENEES-ATLANTIQUES 1,799 0.93 17,453,341 0.69
ILE-DE-FRANCE VAL-D'OISE 1,574 0.82 14,447,586 0.57
AUVERGNE-RHONE-ALPES HAUTE-SAVOIE 1,554 0.81 14,292,165 0.56
LA REUNION LA REUNION 1,414 0.73 14,121,545 0.56
PAYS DE LA LOIRE MAINE-ET-LOIRE 1,102 0.57 9,723,080 0.38
GRAND-EST MARNE 1,035 0.54 10,541,975 0.42
AUVERGNE-RHONE-ALPES ISERE 1,049 0.54 10,055,148 0.40
NORMANDIE SEINE-MARITIME 1,010 0.52 9,513,808 0.38
BOURGOGNE-FRANCHE-COMTE COTE-D'OR 864 0.45 8,747,601 0.35
CENTRE-VAL DE LOIRE LOIRET 849 0.44 8,219,978 0.32
OCCITANIE GARD 825 0.43 7,513,378 0.30
GRAND-EST MOSELLE 806 0.42 9,078,479 0.36
NOUVELLE-AQUITAINE CHARENTE-MARITIME 783 0.41 7,967,300 0.31
CENTRE-VAL DE LOIRE INDRE-ET-LOIRE 780 0.40 7,625,859 0.30
GRAND-EST HAUT-RHIN 760 0.39 9,187,930 0.36
GRAND-EST MEURTHE-ET-MOSELLE 738 0.38 8,475,122 0.33
ILE-DE-FRANCE SEINE-ET-MARNE 718 0.37 7,200,415 0.28
PROVENCE-ALPES-COTE D'AZUR VAUCLUSE 671 0.35 6,669,835 0.26
AUVERGNE-RHONE-ALPES LOIRE 651 0.34 6,441,135 0.25
BRETAGNE MORBIHAN 613 0.32 5,343,186 0.21
AUVERGNE-RHONE-ALPES SAVOIE 593 0.31 5,299,512 0.21
NORMANDIE CALVADOS 581 0.30 6,587,959 0.26
LES-HAUTS-DE-FRANCE SOMME 584 0.30 6,209,240 0.24
PAYS DE LA LOIRE SARTHE 550 0.29 5,892,700 0.23
AUVERGNE-RHONE-ALPES DROME 530 0.27 5,262,660 0.21
NOUVELLE-AQUITAINE HAUTE-VIENNE 500 0.26 6,200,000 0.24
LES-HAUTS-DE-FRANCE OISE 508 0.26 5,647,624 0.22
LES-HAUTS-DE-FRANCE PAS-DE-CALAIS 510 0.26 4,929,643 0.19
OCCITANIE PYRENEES-ORIENTALES 502 0.26 4,662,074 0.18
BRETAGNE FINISTERE 499 0.26 3,980,972 0.16
AUVERGNE-RHONE-ALPES PUY-DE-DOME 484 0.25 4,965,840 0.20
BOURGOGNE-FRANCHE-COMTE DOUBS 457 0.24 3,954,795 0.16
NOUVELLE-AQUITAINE VIENNE 402 0.21 3,862,442 0.15
LES-HAUTS-DE-FRANCE AISNE 385 0.20 4,262,456 0.17
OCCITANIE TARN 358 0.19 2,834,900 0.11
CENTRE-VAL DE LOIRE EURE-ET-LOIR 349 0.18 3,764,416 0.15
AUVERGNE-RHONE-ALPES ALLIER 347 0.18 2,965,497 0.12
OCCITANIE AUDE 331 0.17 3,035,994 0.12
PAYS DE LA LOIRE VENDEE 312 0.16 3,162,504 0.12
CORSE CORSE-DU-SUD 275 0.14 3,345,925 0.13
BOURGOGNE-FRANCHE-COMTE SAONE-ET-LOIRE 267 0.14 2,943,407 0.12
OCCITANIE TARN-ET-GARONNE 257 0.13 2,671,258 0.11
BOURGOGNE-FRANCHE-COMTE YONNE 242 0.13 2,460,346 0.10
AUVERGNE-RHONE-ALPES AIN 245 0.13 2,365,493 0.09
BRETAGNE COTES-D'ARMOR 252 0.13 2,213,180 0.09
CENTRE-VAL DE LOIRE CHER 249 0.13 2,102,805 0.08
NOUVELLE-AQUITAINE CORREZE 228 0.12 2,720,268 0.11
NOUVELLE-AQUITAINE DEUX-SEVRES 222 0.12 2,391,828 0.09
NORMANDIE EURE 236 0.12 2,280,712 0.09
NOUVELLE-AQUITAINE DORDOGNE 230 0.12 1,937,520 0.08
PROVENCE-ALPES-COTE D'AZUR HAUTES-ALPES 222 0.12 1,749,582 0.07
GRAND-EST AUBE 206 0.11 2,728,882 0.11
PAYS DE LA LOIRE MAYENNE 213 0.11 2,606,694 0.10
OCCITANIE AVEYRON 219 0.11 2,628,177 0.10
NORMANDIE MANCHE 219 0.11 1,901,550 0.08
NOUVELLE-AQUITAINE LANDES 196 0.10 1,815,646 0.07
NOUVELLE-AQUITAINE LOT-ET-GARONNE 181 0.09 1,823,282 0.07
CENTRE-VAL DE LOIRE LOIR-ET-CHER 166 0.09 1,577,166 0.06
MARTINIQUE MARTINIQUE 151 0.08 2,177,334 0.09
CENTRE-VAL DE LOIRE INDRE 145 0.08 1,624,145 0.06
PROVENCE-ALPES-COTE D'AZUR ALPES-DE-HAUTE-PROVENCE 127 0.07 1,565,402 0.06
NOUVELLE-AQUITAINE CHARENTE 137 0.07 1,363,013 0.05
GRAND-EST ARDENNES 128 0.07 1,070,592 0.04
BOURGOGNE-FRANCHE-COMTE TERRITOIRE DE BELFORT 112 0.06 1,571,136 0.06
GRAND-EST VOSGES 123 0.06 1,543,158 0.06
GUYANE GUYANE 116 0.06 1,636,748 0.06
CORSE HAUTE-CORSE 120 0.06 1,284,840 0.05
AUVERGNE-RHONE-ALPES CANTAL 118 0.06 1,091,618 0.04
GUADELOUPE GUADELOUPE 101 0.05 1,095,951 0.04
BOURGOGNE-FRANCHE-COMTE NIEVRE 93 0.05 1,067,361 0.04
OCCITANIE HAUTES-PYRENEES 102 0.05 803,352 0.03
NORMANDIE ORNE 82 0.04 764,896 0.03
OCCITANIE LOT 82 0.04 730,538 0.03
OCCITANIE GERS 82 0.04 568,998 0.02
GRAND-EST HAUTE-MARNE 54 0.03 558,036 0.02
BOURGOGNE-FRANCHE-COMTE JURA 65 0.03 461,110 0.02