me ayudan con la 2° parte de este query?

[ingleonidas]

Libras, eso lo intente...

este es el error que me da..

Código:

WITH AllActivities AS ( SELECT ACTIVITY_NAME AS ACTIVIDAD, TO_CHAR(TRUNC(t.CREATION_TIME, 'HH'), 'DD-MON-YYYY HH24:MI:SS') AS HORA, COUNT (*) AS CANTIDAD FROM DB2USER.TASKS t 
WHERE t.CREATION_TIME> TO_DATE ('04-JUN-2013', 'dd - mon - yyyy') 
AND t.CREATION_TIME< TO_DATE ('05-JUN-2013', 'dd - mon - yyyy') 
AND t.BPD_NAME = 'CILI - Control Instrumental' 
AND t.ACTIVITY_NAME IS NOT NULL 
GROUP BY ACTIVITY_NAME, TO_CHAR (TRUNC (t.CREATION_TIME, 'HH'), 'DD-MON-YYYY HH24:MI:SS') ORDER BY ACTIVITY_NAME, 
TO_CHAR (TRUNC (t.CREATION_TIME, 'HH'), 'DD-MON-YYYY HH24:MI:SS') ASC ) 

SELECT AllActivities.actividad,total,g_total,
cast(total / cast(g_total AS decimal(10,4)) AS decimal (10,4)) AS porce  
FROM AllActivities
 LEFT JOIN (SELECT SUM(total) g_total,horario FROM AllActivities GROUP BY horario) t1 ON (t1.horario=AllActivities.horario)

SQL0206N  "HORARIO" no es válida en el contexto donde se usa.  SQLSTATE=42703

SQL0206N  "HORARIO                                                               " 
no es válida en el contexto donde se usa.