BIS 345 mentor Career Begins/bis 345mart.com BIS 345 mentor Career Begins/bis 345mart.com | Page 26

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:
=========================================================
BIS 345 Week 3 iLab

FOR MORE CLASSES VISIT www. bis345mentor. com

Student Name: Using Lab 3, answer the questions and provide copies of your SQL Statements and / or results for each Section listed below Part AJoin 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: