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:
Part C: Inner join two tables( 4 points) a. Paste your SQL Statement here: b. Screen print your results and paste here: Part D: Inner join two tables and apply WHERE clause- Practice # 1( 5 points) c. Paste your SQL Statement here: d. Screen print your results and paste here:
Part E: Inner join two tables- Practice # 2( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part F: Inner join two tables- Practice # 3( 5 points) a. Paste your SQL Statement here: b. Screen print your results and paste here:
Part G: Join two tables with sub-query- Practice # 1( 5 points)