Congestion Easy2

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense