BIS345Lab4EmilioPadulese

BIS345Lab4EmilioPadulese - * ( 1 -OD . Discount )) , 2 ) as...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Lab 4 Part 2 Emilio Padulese
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Lab 4 Part 1 SELECT S . CompanyName , Count ( P . ProductID ) as "No. of Products" FROM Suppliers S INNER JOIN Products P ON S . SupplierID = P . SupplierID GROUP BY S . CompanyName ;
Background image of page 2
Question 2 SELECT O . OrderID , Convert ( varchar , O . OrderDate , 101 ) as OrderDate , ROUND ( Sum ( OD . UnitPrice * OD . Quantity
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: * ( 1 -OD . Discount )) , 2 ) as Total FROM Orders O INNER JOIN [Order Details] OD ON O . OrderID = OD . OrderID GROUP BY O . OrderID , O . OrderDate ; Question 3 Question 4 Question 5 Question 6 Question 7 Question 8...
View Full Document

This note was uploaded on 10/24/2011 for the course BIS345 BIS345 taught by Professor Brudwell during the Spring '10 term at DeVry Ft. Washington.

Page1 / 10

BIS345Lab4EmilioPadulese - * ( 1 -OD . Discount )) , 2 ) as...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online