Difference between revisions of "Congestion Medium"

From SQLZOO
Jump to: navigation, search
(Created page with "<h1>Congestion Charges: medium questions</h1> <div id="6" class='qu'> List the owners (name and address) of Vehicles caught by camera 1 or 18 without duplication. <source l...")
 
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
<h1>Congestion Charges: medium questions</h1>
 
<h1>Congestion Charges: medium questions</h1>
  
<div id="6" class='qu'>
+
<div start="6" class='qu'>
 
List the owners (name and address) of Vehicles caught by camera 1 or 18 without duplication.   
 
List the owners (name and address) of Vehicles caught by camera 1 or 18 without duplication.   
 
<source lang='sql' class='def'>
 
<source lang='sql' class='def'>
Line 7: Line 7:
 
</div>
 
</div>
  
<div id="7" class='qu'>
+
<div class='qu'>
 
Show keepers (name and address) who have more than 5 vehicles.   
 
Show keepers (name and address) who have more than 5 vehicles.   
 
<source lang='sql' class='def'>
 
<source lang='sql' class='def'>
Line 13: Line 13:
 
</div>
 
</div>
  
<div id="8" class='qu'>
+
<div class='qu'>
 
For each vehicle show the number of current permits (suppose today is the 1st of Feb 2007).  
 
For each vehicle show the number of current permits (suppose today is the 1st of Feb 2007).  
 
The list should include the vehicle.s registration and the number of permits.  
 
The list should include the vehicle.s registration and the number of permits.  
Line 21: Line 21:
 
</div>
 
</div>
  
<div id="9" class='qu'>
+
<div class='qu'>
 
Obtain a list of every vehicle passing camera 10 on 25th Feb 2007.  
 
Obtain a list of every vehicle passing camera 10 on 25th Feb 2007.  
 
Show the time, the registration and the name of the keeper if available.   
 
Show the time, the registration and the name of the keeper if available.   
Line 28: Line 28:
 
</div>
 
</div>
  
<div id="10" class='qu'>
+
<div class='qu'>
 
List the keepers who have more than 4 vehicles and one of them must have more than 2 permits.  
 
List the keepers who have more than 4 vehicles and one of them must have more than 2 permits.  
 
The list should include the names and the number of vehicles.     
 
The list should include the names and the number of vehicles.     

Latest revision as of 10:27, 23 July 2012

Congestion Charges: medium questions

List the owners (name and address) of Vehicles caught by camera 1 or 18 without duplication.

 

Show keepers (name and address) who have more than 5 vehicles.

 

For each vehicle show the number of current permits (suppose today is the 1st of Feb 2007). The list should include the vehicle.s registration and the number of permits. Current permits can be determined based on charge types, e.g. for weekly permit you can use the date after 24 Jan 2007 and before 02 Feb 2007.

 

Obtain a list of every vehicle passing camera 10 on 25th Feb 2007. Show the time, the registration and the name of the keeper if available.

 

List the keepers who have more than 4 vehicles and one of them must have more than 2 permits. The list should include the names and the number of vehicles.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense