This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: DeVry University Student Lab Activity BIS 445 Business Intelligence and Data Analysis with Lab Lab 4 Student Answer Sheet Student Name: Adam Gillam Using Lab 4, answer the questions and provide copies of your SQL Statements and results for each Section listed below Step 1: a. Print Screen of the SQL Statement Not sure what I am to do here. b. Print Screen of SQL Results Not sure what I am to do here. Step 2: a. Print Screen of the SQL Statement Select c . state , i . itemType , CAST ( year ( o . orderdate ) as varchar )+ N'-' + cast (( month ( o . orderdate )- 1 ) / 3 + 1 as varchar ) as YearQuarter , round (( od . quantity * od . price )*( 1- od . discount ), 2 ) as Sales From Consumers c , Orders o , OrderLines od , Inventory i Where c . ConsumerID = o . ConsumerID and od . OrderID = o . OrderID and i . InventoryID = od . InventoryID ; 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....
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.
- Spring '11