http://sqlzoo.net/w/index.php?title=Congestion_Hard&feed=atom&action=historyCongestion Hard - Revision history2013-05-23T17:42:39ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=Congestion_Hard&diff=1915&oldid=prevConnor: Created page with "<h1>Congestion Charges: hard questions</h1> <p>You may need to create views to complete these questions - but you do not have permission to create tables or views in the defau..."2012-07-19T13:55:16Z<p>Created page with "<h1>Congestion Charges: hard questions</h1> <p>You may need to create views to complete these questions - but you do not have permission to create tables or views in the defau..."</p>
<p><b>New page</b></p><div><h1>Congestion Charges: hard questions</h1><br />
<p>You may need to create views to complete these questions - but you do not have permission to create tables or views in the default schema.<br />
Your SQL commands are executed by user scott in schema gisq - you may create or drop views and tables in schema scott but not in gisq.</p><br />
<br />
<div class='qu'><br />
When creating a view in scott you must specify the schema name of the sources and the destination. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
There are four types of permit. <br />
The most popular type means that this type has been issued the highest number of times. <br />
Find out the most popular type, together with the total number of permits issued. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
For each of the vehicles caught by camera 19 - show the registration, the earliest time at camera 19 and the time and camera at which it left the zone. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
For all 19 cameras - show the position as IN, OUT or INTERNAL and the busiest hour for that camera. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
Anomalous daily permits. Daily permits should not be issued for non-charging days. <br />
Find a way to represent charging days. Identify the anomalous daily permits. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
Issuing fines: Vehicles using the zone during the charge period, on charging days must be issued with fine notices unless they have a permit covering that day. <br />
List the name and address of such culprits, give the camera and the date and time of the first offence. <br />
<source lang='sql' class='def'><br />
</source><br />
</div></div>Connor