6.
For each "internal" camera show the following details -
the number of images taken
the time of the first image
the time of the last image
(the internal cameras have a null value for the perim attribute)
Results
7.
Obtain a list of every vehicle passing camera 10 on 25th Feb 2003. Show the time, the registration and the name of the keeper if available.
Results
8.
Obtain a list showing the total number of images taken hour by hour for cameras 18 and 19
Results
9.
For each of the vehicles caught by camera 18 - show the registration, the earliest time at camera 18 and the time and camera at which it left the zone.
Results
10.
For all 19 cameras - show the position as IN, OUT or INTERNAL and the busiest hour for that camera.
