easy computer work

profilesharadgreen
form2.docx
Home>Computer Science homework help>easy computer work

DeVry University

Student Lab Activity

BIS 345 Data Analysis for Decision Making

Lab 2 Student Answer Sheet

Student Name:

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

Part A: Employee List (4 points)

a. What does Left function do?

b. Screen print your results and paste here:

Part B: Date Function (4 points)

a. How do you display the year part of a date?

b. Paste your SQL Statement here:

c. Screen print your results and paste here:

Part C: Using a Calculation in a Query (4 points)

a. Paste your SQL Statement here

b. Screen print your results and paste here:

Part D: Practice SUM function (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part E: Practice Average, Maximum, and Minimum function (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part F: Practice function when value is NULL (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part G: Using GROUP BY clause (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part H: Using function on WHERE clause (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part I: Using function to calculate date difference (5 points)

a. Paste your SQL Statement here:

b. Screen print your results and paste here:

Part J: Using conversion function (5 points)

a. What do you use to convert the numerical data into VARCHAR data type?

b. Paste your SQL Statement here:

c. 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.

.

Lab2_Questions.docx Page 2 of 2