Gillam_A_Lab4_Questions

Gillam_A_Lab4_Questions - DeVry University Student Lab...

Info iconThis preview shows pages 1–2. 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 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.

Page1 / 6

Gillam_A_Lab4_Questions - DeVry University Student Lab...

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

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