depenses_par_paiement (view)

Data license: Privé

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

methode_paiement nb_postes total
Prélèvement 9 1049.36
Carte Gold 8 549.3100000000001
PayPal 3 13.16

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW depenses_par_paiement AS
        SELECT methode_paiement,
               COUNT(*) as nb_postes,
               SUM(montant) as total
        FROM depenses
        GROUP BY methode_paiement
        ORDER BY total DESC;