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 :