1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT Tfos_depenses.Article,
(select count(Tfos_depenses.Article) as NB_Articles
FROM Tfos_depenses
where Tfos_depenses.Objet like 'E328/Z00463%') as Allier,
(select count(Tfos_depenses.Article) as NB_Articles
FROM Tfos_depenses
where Tfos_depenses.Objet like 'E328/Z00462%' ) as Creuse,
(select count(Tfos_depenses.Article) as NB_Articles
FROM Tfos_depenses
where Tfos_depenses.Objet like 'E328/Z00464%' ) as `Haute Loire`,
(select count(Tfos_depenses.Article) as NB_Articles
FROM Tfos_depenses
where Tfos_depenses.Objet like 'E328/Z00461%' ) as `Puy de Dome`
FROM Tfos_depenses
where Tfos_depenses.Article != ""
group by Tfos_depenses.Article |
Partager