select SCI_ATTR_TABLE.SCI_ATTR, sum(SCI_ATTR_TABLE.SCI_VALUE) as "SOMVAL", PIE_INDEX
from counter_snapshot,(
select counter_schedule.SCI_DATE, counter_schedule.SCI_WEEKDAY, counter_schedule.SCI_WEEK, counter_schedule.SCI_WORK_DAY,
'Work' as "SCI_ATTR", '2' as "PIE_INDEX", counter_schedule.SCI_WORK_TIME as "SCI_VALUE"
from counter_schedule
where counter_schedule.SCI_SNAPSHOT_ID = 2
union
select counter_schedule.SCI_DATE, counter_schedule.SCI_WEEKDAY, counter_schedule.SCI_WEEK, counter_schedule.SCI_WORK_DAY,
'Travel' as "SCI_ATTR", '1' as "PIE_INDEX", counter_schedule.SCI_TRAVEL_TIME as "SCI_VALUE"
from counter_schedule
where counter_schedule.SCI_SNAPSHOT_ID = 2
union
select counter_schedule.SCI_DATE, counter_schedule.SCI_WEEKDAY, counter_schedule.SCI_WEEK, counter_schedule.SCI_WORK_DAY,
'Rest' as "SCI_ATTR", '3' as "PIE_INDEX", counter_schedule.SCI_AVAILABLE_TIME as "SCI_VALUE"
from counter_schedule
where counter_schedule.SCI_SNAPSHOT_ID = 2
)
as "SCI_ATTR_TABLE"
group by SCI_ATTR_TABLE.SCI_ATTR, PIE_INDEX
order by PIE_INDEX
Partager