--001 

select count(1) Countx from  V8_REP_MAINTENANCE_INFOS a
where a.WACT_COMPLTIME is null;


--002 

select b.*,
decode(mod(rownum,2), 0, 'WhiteLine', 'GreyLine') cssclass
 from 
(
select a.*,
         DECODE (a.wact_place_type,
                 1, 'Room',
                 2, 'Function Space',
                 3, 'Location',
                 4, 'Public Place'
                ) placetype
 from  V8_REP_MAINTENANCE_INFOS a
where a.WACT_COMPLTIME is null
order by a.EMP_NAME asc) b;


--003 

select emp_name, count(1) OpenTasks from  V8_REP_MAINTENANCE_INFOS a
where a.WACT_COMPLTIME is null
group by a.EMP_NAME;
