Congestion Medium2

From SQLZOO
Revision as of 14:52, 19 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Congestion Charges: medium questions

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)

 

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.

 

Obtain a list showing the total number of images taken hour by hour for cameras 18 and 19

 

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.

 

For all 19 cameras - show the position as IN, OUT or INTERNAL and the busiest hour for that camera.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense