Adam_Gillam_Lab4_Questions

Adam_Gillam_Lab4_Questions - DeVry University Student Lab...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: DeVry University Student Lab Activity BIS 345 Data Analysis for Decision Making Lab 4A Student Answer Sheet Student Name: Adam Gillam Using Lab 4 provide copies of your SQL Statements and/or results for each Section listed below Part A Supplier and product list (10 points) a. Paste your SQL Statement here: 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 ; b. Screen print your results and paste here: Copyright © 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation. . 6c9ead3d22a480635b24f0e676584109dbe8f22f Page 1 of 8 DeVry University Student Lab Activity BIS 345 Data Analysis for Decision Making Part B: Order information (10 points) a. Paste your SQL Statement here: Select O . OrderID , Convert ( varchar , O . OrderDate , 101 ) as OrderDate , Round ( Sum ( OD . UnitPrice * OD . Quantity * ( 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 ; b. Screen print your results and paste here: Copyright © 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without...
View Full Document

This note was uploaded on 05/18/2011 for the course BIS 450 taught by Professor Ickbob during the Spring '11 term at DeVry Buckhead.

Page1 / 8

Adam_Gillam_Lab4_Questions - DeVry University Student Lab...

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

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