repartition_budget (view)

Data license: Privé

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

categorie montant pourcentage
Dépenses fixes 1611.82 52.85
Investissements 692.0 22.69
Reste disponible 746.18 24.46

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW repartition_budget AS
        SELECT 'Dépenses fixes' as categorie, 1611.82 as montant, 52.85 as pourcentage
        UNION ALL
        SELECT 'Investissements', 692.00, 22.69
        UNION ALL
        SELECT 'Reste disponible', 746.18, 24.46;