easy computer work

Student Name:

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

Part A: Customer List (4 points)

a. What does the ORDER BY clause do?

b. Screen print your results and paste here:

Part B: Customer List with only customers In France or Germany (4 points)

a. What do you need to fill in the WHERE clause?

b. Paste your SQL Statement here:

c. Screen print your results and paste here:

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

a. Screen print your results and paste here:

Part D: Products that are discontinued (5 points)

a. What condition should you put on WHERE clause?

b. Paste your SQL Statement here:

c. Screen print your results and paste here:

Part E: Practice using the BETWEEN operator (5 points)

a. What condition should you put after the WHERE clause when using the BETWEEN operator?

b. Paste your SQL Statement here:

c. Screen print your results and paste here:

Part F: Practice using the “IN” operator (5 points)

a. What does the “IN” operator do?

b. Screen print your results and paste here:

Part G: Understanding “NULL” (5 points)

a. What is NULL?

b. How is NULL different from blank spaces?

c. Can NULL only be used with IS operator?

d. What if you change the “IS” operator to “=”?

Part H: Using a composite condition (5 points)

a. What did you put in the where clause?

b. Is ShipCountry = ‘France’ the same as SHIPCOUNTRY = ‘France’?

c. Is ShipCountry= ‘France’ the same as ShipCountry= ‘FRANCE’?

d. Are the column, table and value parts of the SQL script case sensitive?

e. Paste your SQL Statement here:

f. Screen print your results and paste here:

Part I: Using a “DATE” type variable and Concatenating Column Output (5 points)

a. In the Select Statement, how does SELECT FirstName + ' ' + LastName as "Name" affect the output results?

b. Screen print your results and paste here:

Part J: Using the “LIKE” operator and the “%” wildcard (6 points)

a. What did you put in the WHERE clause's LIKE operator?

b. What would happen if you did not use the “%” wildcard with the LIKE operator?

c. Paste your SQL Statement here:

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

.

Lab1_Questions.docx Page 3 of 3