http://sqlzoo.net/w/index.php?title=AdventureWorks_resit_questions&feed=atom&action=history
AdventureWorks resit questions - Revision history
2013-05-18T23:53:14Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=AdventureWorks_resit_questions&diff=3593&oldid=prev
Marcin at 06:28, 14 August 2012
2012-08-14T06:28:32Z
<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 06:28, 14 August 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>{{AdventureWorks Assessment}}</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>{{AdventureWorks Assessment}}</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;"></ins></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;"></ins></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;"></ins></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;"></ins></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;"></ins></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;"></ins></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;"></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==AdventureWorks: resit questions==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==AdventureWorks: resit questions==</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>
</table>
Marcin
http://sqlzoo.net/w/index.php?title=AdventureWorks_resit_questions&diff=3390&oldid=prev
Andr3w at 20:01, 9 August 2012
2012-08-09T20:01:40Z
<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 20:01, 9 August 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</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;">{{AdventureWorks Assessment}}</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==AdventureWorks: resit questions==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==AdventureWorks: resit questions==</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 colspan="2" class="diff-lineno">Line 35:</td>
<td colspan="2" class="diff-lineno">Line 36:</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 class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></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;">{{AdventureWorks Assessment}}</ins></div></td></tr>
</table>
Andr3w
http://sqlzoo.net/w/index.php?title=AdventureWorks_resit_questions&diff=1902&oldid=prev
Marek: Created page with "==AdventureWorks: resit questions== <div class='qu'> <p class='imper'>List the SalesOrderNumber for the customer 'Good Toys' 'Bike World'</p> <source lang='sql' class='def'> ..."
2012-07-19T13:28:49Z
<p>Created page with "==AdventureWorks: resit questions== <div class='qu'> <p class='imper'>List the SalesOrderNumber for the customer 'Good Toys' 'Bike World'</p> <source lang='sql' class='def'> ..."</p>
<p><b>New page</b></p><div>==AdventureWorks: resit questions==<br />
<br />
<div class='qu'><br />
<p class='imper'>List the SalesOrderNumber for the customer 'Good Toys'<br />
'Bike World'</p><br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
<p class='imper'>List the ProductName and the quantity of what was ordered by 'Futuristic Bikes'</p><br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
<p class='imper'>List the name and addresses of companies containing the word 'Bike' (upper<br />
or lower case) and companies containing 'cycle' (upper<br />
or lower case). Ensure that the 'bike's are listed before the 'cycles's.<br />
</p><br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
<p class='imper'>Show the total order value for each CountryRegion. List by value with the<br />
highest first.</p><br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
<p class='imper'>Find the best customer in each region.</p><br />
<source lang='sql' class='def'><br />
</source><br />
</div></div>
Marek