Congestion Easy2

From SQLZOO
Jump to navigation Jump to search

Congestion Charges Southwind database: easy questions

Show the name and address of the keeper of vehicle SO 02 ATP

List the permits that have purchased for vehicle SO 02 BTP that have a start date before 1 Feb 2003. Give the start date and chargeType.

List the number of permits by charge type. Your answer should show how many daily permits have been issued, how many weekly permits have been issued and how many annual permits have been issued. The list must NOT include the number of monthly permits.

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

Show the number of images captured by camera 18