1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| SELECT TO_CHAR(A.wodate, 'YYYY') AS datepanne, count(wo.wonum)
from wo, (
select distinct wodate, woe.lastname, woe.wonum
from woe, equip
WHERE WOE.LASTNAME <> 'SDP_AUTOMAT_EDP'
and woe.WODATE between TO_DATE('01/01/2009','DD/MM/YYYY') and TO_DATE('31/12/2013 23:59','DD/MM/YYYY HH24:MI')
and woe.eqnum = equip.eqnum
and equip.famille = 'PEAGE'
and equip.eqtype in ('BTT')
) A
where
wo.wonum = A.wonum
and wo.wotype = 'CURATIF'
group by TO_CHAR(A.wodate, 'YYYY')
order by datepanne asc; |
Partager