Bis345 Lab 3

Lab 3 Student Answer Sheet

Student Name:

Using Lab 3, answer the questions and provide copies of your SQL Statements and/or results for each Section listed below

Part A Join two tables (4 points)

a. Paste your SQL Statement here:

Select r.RegionDescription, t.TerritoryDescription

From Region r

Inner Join Territories t on r.RegionID = t.RegionID

Order by r.RegionDescription, t.TerritoryDescription

a. Screen print your results and paste here:

Part B: Join two tables and apply WHERE clause (4 points)

a. Paste your SQL Statement here:

Select c.CategoryName, p.ProductName, p.UnitPrice, p.UnitsInStock, p.ReorderLevel

From Products p

Inner Join Categories c on c.CategoryID = p.CategoryID

Where p.UnitsInStock < p.ReorderLevel

Order By c.CategoryName, p.ProductName

b. Screen print your results and paste here:

Part C: Inner join two tables (4 points)

a. Paste your SQL Statement here:

Select o.OrderID, o.OrderDate, od.ProductID, od.UnitPrice, od.Quantity

From Orders o

Inner Join [Order Details] od on o.OrderID = od.OrderID

b. Screen print your results and paste here:

Part D: Inner join two tables and apply WHERE clause - Practice # 1 (5 points)

a. Paste your SQL Statement here:

Select e.LastName, e.FirstName, o.OrderID, o.OrderDate

From Orders o

Inner Join Employees e on o.EmployeeID = e.EmployeeID

Where e.FirstName = 'Laura'

And e.LastName = 'Callahan'

b. Screen print your results and paste here:

Part E: Inner join two tables - Practice #2 (5 points)

a. Paste your SQL Statement here:

Select p.ProductName, s.CompanyName, s.City

From Products p

Inner Join Suppliers s on p.SupplierID = s.SupplierID

b. Screen print your results and paste here:

Part F: Inner join two tables - Practice #3 (5 points)

a. Paste your SQL Statement here:

Select o.OrderID, o.ShippedDate, s.CompanyName

From Orders o

Inner Join Shippers s on o.ShipVia = s.ShipperID

b. Screen print your results...