This preview shows pages 1–2. Sign up to view the full content.
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
- Spring '11