SQLzoo.net

AdventureWorks database

Graduated questions

• Easy questions: 1..5
• Medium questions: 6..10
• Hard questions: 11..15
• Resit questions: 1..5

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

CustomerAW(CustomerID, FirstName, MiddleName, LastName, CompanyName, EmailAddress)
 
CustomerAddress(CustomerID, AddressID, AddressType)
 
Address(AddressID, AddressLine1, AddressLine2, City, StateProvince, CountyRegion, PostalCode)
 
SalesOrderHeader(SalesOrderID, RevisionNumber, OrderDate, CustomerID, BillToAddressID, ShipToAddressID, ShipMethod, SubTotal, TaxAmt, Freight)
 
SalesOrderDetail(SalesOrderID, SalesOrderDetailID, OrderQty, ProductID, UnitPrice, UnitPriceDiscount)
 
ProductAW(ProductID, Name, Color, ListPrice, Size, Weight, ProductModelID, ProductCategoryID)
 
ProductModel(ProductModelID, Name)
 
ProductCategory(ProductCategoryID, ParentProductCategoryID Name)
 
ProductModelProductDescription(ProductModelID, ProductDescriptionID, Culture)
 
ProductDescription(ProductDescriptionID, Description)
 

Sample queries

SELECT CompanyName
  FROM CustomerAW
 WHERE FirstName='James'
   AND MiddleName='D.'
   AND LastName='Kramer'
 

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'
 

SELECT OrderQty,Name,ListPrice
  FROM SalesOrderHeader NATURAL JOIN SalesOrderDetail 
                        NATURAL JOIN ProductAW
WHERE CustomerID=635