Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement