SELECT COUNT(one.poi_id), one.POI_ID, one."NAMES", one.OC_POI_CATEGORY_ID, one.ADDRESS,  one."DATE", CASE
  WHEN one.Address LIKE ' ' THEN 'NO'
  ELSE 'YES'
  END HAS
FROM (SELECT p.POI_ID, initcap(p.NAME) "NAMES", p.OC_POI_CATEGORY_ID,
                  CASE
                    WHEN p.STREET IS NULL
                    OR p.STREET_NR IS NULL
                    OR p.POST_CODE IS NULL
                    OR p.location IS NULL
                    OR p.country IS NULL THEN ' '
                    ELSE TRIM(BOTH ' ' FROM p.STREET)||' '||TRIM(BOTH ' ' FROM p.STREET_NR)||' '||TRIM(BOTH ' ' FROM p.POST_CODE)||' '||TRIM(BOTH ' ' FROM p.LOCATION)||' '||TRIM(BOTH ' ' FROM p.COUNTRY)
                  END "ADDRESS", TO_CHAR(p.LM_DATE, 'DD-MON-YYYY HH24:MI:SS') "DATE"
              FROM OC_POI p,  WBS w, OC_POI_LOAD_DATA o, OPERATION_CENTER oc
              WHERE p.poi_id=w.poi_id
              AND w.operation_center_id=oc.operation_center_id
              AND o.ref_number!=w.ref_number
              AND oc.name != o.operation_center_name
              AND w.wbs_LEVEL=1
              AND o.EXISTING_RECORD LIKE 'N') one
WHERE to_date(one."DATE",'DD-MON-YY HH24:MI:SS') BETWEEN to_date('01-JAN-2012 00:00:00', 'DD-MON-YY HH24:MI:SS') AND to_date('01-JAN-2014 00:00:00', 'DD-MON-YY HH24:MI:SS')
AND to_char(to_date(one."DATE",'DD-MON-YY HH24:MI:SS'), 'DAY') LIKE '%MONDAY%'
AND to_char(to_date(one."DATE",'DD-MON-YY HH24:MI:SS'), 'HH24:MI') <= '12:00'
GROUP BY one.POI_ID, one."NAMES", one.OC_POI_CATEGORY_ID, one.ADDRESS, one."DATE"
ORDER BY 1;