Bonjour à tous !

Je viens vers vous car je n'arrive pas à résoudre un problème en lien avec la requête suivante :

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
J'obtiens alors l'érreur suivante, c'est probablement une connerie, mais je ne vois plus rien ....

as "SCI_ATTR_TABLE"

*

ERROR at line 18:

ORA-00933: SQL command not properly ended
Merci de votre aide !