BIS 345 Week 1 iLab NEW

Student Name: 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)

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

Part D: Products that are discontinued (5 points)

Part E: Practice

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

Part G: Understanding “NULL” (5 points)

Part H: Using a

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

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