http://sqlzoo.net/w/index.php?title=Congestion_Easy&feed=atom&action=historyCongestion Easy - Revision history2013-06-19T06:36:05ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=Congestion_Easy&diff=1912&oldid=prevConnor at 13:44, 19 July 20122012-07-19T13:44:28Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:44, 19 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 11:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></div></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='qu'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='qu'></div></td></tr>
</table>Connorhttp://sqlzoo.net/w/index.php?title=Congestion_Easy&diff=1911&oldid=prevConnor: Created page with "<h1>Congestion Charges: easy questions</h1> <div class='qu'> Show the name and address of the keeper of vehicle SO 02 PSP. <source lang='sql' class='def'> </source> </div> ..."2012-07-19T13:43:36Z<p>Created page with "<h1>Congestion Charges: easy questions</h1> <div class='qu'> Show the name and address of the keeper of vehicle SO 02 PSP. <source lang='sql' class='def'> </source> </div> ..."</p>
<p><b>New page</b></p><div><h1>Congestion Charges: easy questions</h1><br />
<br />
<div class='qu'><br />
Show the name and address of the keeper of vehicle SO 02 PSP. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
Show the number of cameras that take images for incoming vehicles. <br />
<source lang='sql' class='def'><br />
</source><br />
<br />
<div class='qu'><br />
List the image details taken by Camera 10 before 26 Feb 2007. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
List the number of images taken by each camera. <br />
Your answer should show how many images have been taken by camera 1, camera 2 etc. <br />
The list must NOT include the images taken by camera 15, 16, 17, 18 and 19. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
A number of vehicles have permits that start on 30th Jan 2007. <br />
List the name and address for each keeper in alphabetical order without duplication. <br />
<source lang='sql' class='def'><br />
</source><br />
</div></div>Connor