Connor: Created page with "

Congestion Charges Southwind database: easy questions

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

2012-07-19T14:50:34Z

Created page with "<h1>Congestion Charges Southwind database: easy questions</h1> <div class='qu'> Show the name and address of the keeper of vehicle SO 02 ATP <source lang='sql' class='def'>..."

New page

<h1>Congestion Charges Southwind database: easy questions</h1>

<div class='qu'>
Show the name and address of the keeper of vehicle SO 02 ATP
<source lang='sql' class='def'>
</source>
</div>

<div class='qu'>
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.
<source lang='sql' class='def'>
</source>
</div>

<div class='qu'>
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.
<source lang='sql' class='def'>
</source>
</div>

<div class='qu'>
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.
<source lang='sql' class='def'>
</source>
</div>

<div class='qu'>
Show the number of images captured by camera 18
<source lang='sql' class='def'>
</source>
</div>

Congestion Easy2 - Revision history

Connor: Created page with "

Congestion Charges Southwind database: easy questions