AdventureWorks - Revision history

Andr3w at 19:56, 9 August 2012

2012-08-09T19:56:02Z

Andr3w at 19:49, 9 August 2012

2012-08-09T19:49:23Z

Marek at 13:30, 19 July 2012

2012-07-19T13:30:53Z

Marek at 13:04, 19 July 2012

2012-07-19T13:04:44Z

Marek: Created page with "Graduated questions * Easy questions: 1..5 * Medium questions: 6..10 * [[AdventureWorks hard questions|H..."

2012-07-19T12:19:06Z

Created page with "Graduated questions * Easy questions: 1..5 * Medium questions: 6..10 * [[AdventureWorks hard questions|H..."

New page

Graduated questions

* [[AdventureWorks easy questions|Easy questions: 1..5]]
* [[AdventureWorks medium questions|Medium questions: 6..10]]
* [[AdventureWorks hard questions|Hard questions: 11..15]]
* [[AdventureWorks resit questions|Resit questions: 1..5]]

This data is based on Microsoft's AdventureWorksLT database. Access version: AdventureWorksLT.mdb

@@ Line 69: / Line 69: @@
 </source>
 </div>
-{{AdevntureWorks Assessment}}
+{{AdventureWorks Assessment}}

@@ Line 6: / Line 6: @@
 * [[AdventureWorks resit questions|Resit questions: 1..5]]
-This data is based on Microsoft's AdventureWorksLT database. Access version: AdventureWorksLT.mdb
+This data is based on [http://www.codeplex.com/MSFTDBProdSamples/Wiki/View.aspx?title=%20AdventureWorksLTDiagram&referringTitle=AWSchemaDiag Microsoft's AdventureWorksLT] database. Access version: [http://sqlzoo.net/~andrew/big/AdventureWorksLT.mdb AdventureWorksLT.mdb]
 {{AdventureWorks tables}}

← Older revision		Revision as of 13:04, 19 July 2012
Line 7:		Line 7:

	This data is based on Microsoft's AdventureWorksLT database. Access version: AdventureWorksLT.mdb		This data is based on Microsoft's AdventureWorksLT database. Access version: AdventureWorksLT.mdb
		+
		+	{{AdventureWorks tables}}
		+
		+	==Sample queries==
		+
		+	<div class='qu'>
		+	<p class='imper'>Show the CompanyName for James D. Kramer</p>
		+
		+	<source lang='sql' class='def'>
		+	SELECT CompanyName
		+	FROM CustomerAW
		+	WHERE FirstName='James'
		+	AND MiddleName='D.'
		+	AND LastName='Kramer'
		+	</source>
		+
		+	<source lang='sql' class='ans'>
		+	SELECT CompanyName
		+	FROM CustomerAW
		+	WHERE FirstName='James'
		+	AND MiddleName='D.'
		+	AND LastName='Kramer'
		+	</source>
		+	</div>
		+
		+	<div class='qu'>
		+	<p class='imper'>Show all the addresses listed for 'Modular Cycle Systems'</p>
		+
		+	<source lang='sql' class='def'>
		+	SELECT CompanyName,AddressType,AddressLine1
		+	FROM CustomerAW JOIN CustomerAddress
		+	ON (CustomerAW.CustomerID=CustomerAddress.CustomerID)
		+	JOIN Address
		+	ON (CustomerAddress.AddressID=Address.AddressID)
		+	WHERE CompanyName='Modular Cycle Systems'
		+	</source>
		+
		+	<source lang='sql' class='ans'>
		+	SELECT CompanyName,AddressType,AddressLine1
		+	FROM CustomerAW JOIN CustomerAddress
		+	ON (CustomerAW.CustomerID=CustomerAddress.CustomerID)
		+	JOIN Address
		+	ON (CustomerAddress.AddressID=Address.AddressID)
		+	WHERE CompanyName='Modular Cycle Systems'
		+	</source>
		+	</div>
		+
		+	<div class='qu'>
		+	<p class='imper'>Show OrdeQty, the Name and the ListPrice of the order made by
		+	CustomerID 635</p>
		+
		+	<source lang='sql' class='def'>
		+	SELECT OrderQty,Name,ListPrice
		+	FROM SalesOrderHeader NATURAL JOIN SalesOrderDetail
		+	NATURAL JOIN ProductAW
		+	WHERE CustomerID=635
		+	</source>
		+
		+	<source lang='sql' class='ans'>
		+	SELECT OrderQty,Name,ListPrice
		+	FROM SalesOrderHeader NATURAL JOIN SalesOrderDetail
		+	NATURAL JOIN ProductAW
		+	WHERE CustomerID=635
		+	</source>
		+	</div>

@@ Line 1: / Line 1: @@
 Graduated questions
+{{AdventureWorks Assessment}}
-* [[AdventureWorks easy questions|Easy questions: 1..5]]
-* [[AdventureWorks medium questions|Medium questions: 6..10]]
-* [[AdventureWorks hard questions|Hard questions: 11..15]]
-* [[AdventureWorks resit questions|Resit questions: 1..5]]
 This data is based on [http://www.codeplex.com/MSFTDBProdSamples/Wiki/View.aspx?title=%20AdventureWorksLTDiagram&referringTitle=AWSchemaDiag Microsoft's AdventureWorksLT] database. Access version: [http://sqlzoo.net/~andrew/big/AdventureWorksLT.mdb AdventureWorksLT.mdb]
@@ Line 73: / Line 69: @@
 </source>
 </div>