1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT (date_part('week',dossier.date_creation) - date_part('week',max(changement_etat.date))) as Temps ,date_part('year', dossier.date_creation)as année,
CASE
WHEN date_part('month', dossier.date_creation) = '01' THEN 'Janvier'
WHEN date_part('month', dossier.date_creation) = '02' THEN 'Février'
WHEN date_part('month', dossier.date_creation) = '03' THEN 'Mars'
WHEN date_part('month', dossier.date_creation) = '04' THEN 'Avril'
WHEN date_part('month', dossier.date_creation) = '05' THEN 'Mai'
WHEN date_part('month', dossier.date_creation) = '06' THEN 'Juin'
WHEN date_part('month', dossier.date_creation) = '08' THEN 'Aout'
WHEN date_part('month', dossier.date_creation) = '09' THEN 'Septembre'
WHEN date_part('month', dossier.date_creation) = '10' THEN 'Octobre'
WHEN date_part('month', dossier.date_creation) = '11' THEN 'Novembre'
WHEN date_part('month', dossier.date_creation) = '12' THEN 'Décembre'
end as "Mois"
from dossier,changement_etat
where changement_etat.fk_id_dossier = dossier.id_dossier
group by date_part('week', dossier.date_creation), date_part('week',changement_etat.date), date_part('month', dossier.date_creation), date_part('year', dossier.date_creation),id_dossier
order by date_part('year', dossier.date_creation) desc |
Partager