easy computer work

DeVry University

Student Lab Activity

BIS 345 Data Analysis for Decision Making

Lab 3 Student Answer Sheet

Student Name:

Using Lab 3, answer the questions and provide copies of your SQL Statements and/or results for each Section listed below

Part A Join two tables (4 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part B: Join two tables and apply WHERE clause (4 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part C: Inner join two tables (4 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part D: Inner join two tables and apply WHERE clause - Practice # 1 (5 points)

c. Paste your SQL Statement here:

d. Screen print your results and paste here:

Part E: Inner join two tables - Practice #2 (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part F: Inner join two tables - Practice #3 (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part G: Join two tables with sub-query - Practice # 1 (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part H: Join two tables with sub-query -Practice #2 (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here

Part I: Single table join (5 points)

c. Paste your SQL Statement here:

d. Screen print your results and paste here:

Part J: Complex join (5 points)

a. Paste your SQL Statement here:

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.

.

Lab3_Questions.docx Page 2 of 2