BIS 345 Week 3 iLab
For more course tutorials visit www. tutorialrank. com
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: ===============================================
BIS 345 Week 3 iLab
For more course tutorials visit www. tutorialrank. 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 A Join two tables( 4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: