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 :