select
to_char(work_date,
'yyyy-mm'
) yearMonth,staff_name,sum(effort) sum
from task_info,staff_info
where task_info.staff_sril=staff_info.staff_sril
and work_date >= to_date( ' 2007-05-01 ' , 'yyyy-mm-dd' )
and work_date<=to_date( ' 2007-05-06 ' , 'yyyy-mm-dd' )
group by cube(to_char(work_date, 'yyyy-mm' ),staff_name)
order by to_char(work_date, 'yyyy-mm' ) asc
from task_info,staff_info
where task_info.staff_sril=staff_info.staff_sril
and work_date >= to_date( ' 2007-05-01 ' , 'yyyy-mm-dd' )
and work_date<=to_date( ' 2007-05-06 ' , 'yyyy-mm-dd' )
group by cube(to_char(work_date, 'yyyy-mm' ),staff_name)
order by to_char(work_date, 'yyyy-mm' ) asc