Student Name:
Using Lab 5, provide copies of your SQL Statements, results and reports for each Section listed below
Part A
Product and Category dataset (7 points)
a. Paste your SQL Statement here:
b. Screen print your results and paste here:
Part B: Product and Category report (10 points)
a. Paste your report here:
Part C: Sales and Territory dataset (10 points)
a. Paste your SQL Statement here:
b. Screen print your results and paste here:
Part D: Sales and Territory, report (10 points)
a. Paste your report here:
Part E: Sales and Territory Report Interpretation (10 points)
Write your interpretation of the results. The interpretation must be a minimum of one paragraph (3 to 5 well-formed sentences) with no spelling or grammatical errors. Based on these results, what other data would you recommend that the business consider for further analysis?
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.
.
Lab5_Questions.docx Page 1 of 1