--2.4
SELECT  v.NUMBERPLATE
    FROM person p, vd_poi vdp, vehicle_data vd, vehicle v, vo_vehicle_category vovc, vehicle_owner vo
    WHERE vdp.vehicle_data_id     = vd.vehicle_data_id
        AND vd.VEHICLE_ID            = v.VEHICLE_ID
        AND v.VO_VEHICLE_CATEGORY_ID = vovc.VO_VEHICLE_CATEGORY_ID
        AND vovc.VEHICLE_OWNER_ID    = vo.VEHICLE_OWNER_ID
        AND vdp.poi_id              != p.home_poi_id
        AND v.PERSON_ID             = p.PERSON_ID
        AND TRUNC(vd.GPS_FULL_DATE)  = to_date('10-DEC-13','DD-MON-YY')
        AND vo.VEHICLE_OWNER_ID      = 100553
    GROUP BY v.NUMBERPLATE;

-- 2.5
SELECT  v.NUMBERPLATE, ocp.POST_CODE, ocp.LOCATION, LISTAGG(vd.RG_POST_CODE
        || ' '
        || vd.RG_LOCATION, '-') WITHIN GROUP (
    ORDER BY vd.VEHICLE_ID) "Start day event", COUNT(*)
    FROM person p, vd_poi vdp, vehicle_data vd, vehicle v, vo_vehicle_category vovc, vehicle_owner vo, oc_poi ocp
    WHERE vdp.vehicle_data_id     = vd.vehicle_data_id
        AND vd.VEHICLE_ID            = v.VEHICLE_ID
        AND v.VO_VEHICLE_CATEGORY_ID = vovc.VO_VEHICLE_CATEGORY_ID
        AND vovc.VEHICLE_OWNER_ID    = vo.VEHICLE_OWNER_ID
        AND vdp.poi_id              != p.home_poi_id
        AND v.PERSON_ID             = p.PERSON_ID
        AND vdp.POI_ID               = ocp.POI_ID
        AND vo.VEHICLE_OWNER_ID      = 100553
        AND TRUNC(vd.GPS_FULL_DATE) > to_date('10-NOV-13','DD-MON-YY') -- AND to_date('10-DEC-13','DD-MON-YY') -- = sysdate - 30
        AND TRUNC(vd.GPS_FULL_DATE) <= to_date('10-DEC-13','DD-MON-YY')
        -- and rownum <= 15
    GROUP BY v.NUMBERPLATE, ocp.POST_CODE, ocp.LOCATION
    HAVING COUNT(*) > 5;

-- 2.5 no listaag
SELECT  v.NUMBERPLATE, ocp.POST_CODE, ocp.LOCATION,
        vd.RG_POST_CODE
        || '-'
        || vd.RG_LOCATION "Start day event", COUNT(*)
    FROM person p, vd_poi vdp, vehicle_data vd, vehicle v, vo_vehicle_category vovc, vehicle_owner vo, oc_poi ocp
    WHERE vdp.vehicle_data_id     = vd.vehicle_data_id
        AND vd.VEHICLE_ID            = v.VEHICLE_ID
        AND v.VO_VEHICLE_CATEGORY_ID = vovc.VO_VEHICLE_CATEGORY_ID
        AND vovc.VEHICLE_OWNER_ID    = vo.VEHICLE_OWNER_ID
        AND vdp.poi_id              != p.home_poi_id
        AND v.PERSON_ID              = p.PERSON_ID
        AND vdp.POI_ID               = ocp.POI_ID
        AND vo.VEHICLE_OWNER_ID      = 100553
        AND TRUNC(vd.GPS_FULL_DATE)  > to_date('10-NOV-13','DD-MON-YY') -- AND to_date('10-DEC-13','DD-MON-YY') -- = sysdate - 30
        AND TRUNC(vd.GPS_FULL_DATE) <= to_date('10-DEC-13','DD-MON-YY')
        --and rownum <= 15
    GROUP BY v.NUMBERPLATE, ocp.POST_CODE, ocp.LOCATION, vd.RG_POST_CODE
        || '-'
        || vd.RG_LOCATION
    HAVING COUNT(*) > 5;