A Gentle Introduction to

SQL


Pick an engine:

Congestion Charges: easy questions

1 Show the name and address of the keeper of vehicle SO 02 PSP.

2 Show the number of cameras that take images for incoming vehicles.

3 List the image details taken by Camera 10 before 26 Feb 2003.

4 List the number of images taken by each camera. Your answer should show how many images have been taken by camera 1, camera 2 etc. The list must NOT include the images taken by camera 15, 16, 17, 18 and 19.

5 A number of vehicles have permits that start on 30th Jan 2003. List the name and address for each keeper in alphabetical order without duplication.