SQ in PL$/$SQL

$-$Use the table named, 'yourfirstname new items' for question $3$ through $7.$

$3.$ Write SQL statements to create a table named 'yourfirstname. new items' and insert the

provided data into it$.$

Include your complete code below.

Provide a screenshot showing all three records in the table.

$4.$ Write a SQL statement to update 'yourfirstname, grocery, items' table with the 'brand' and

'description' values from 'yourfirstname. new.items' table where 'productid' values match.

If there is no match, insert a new row into 'yourfirstname, grocery. items' table using the

'MERGE INTO' statement. Do not execute the statement yet.

Include your complete code below.

$5.$ How many rows will be updated by the SQL statement in question $4?$

Write your answer below.

$6.$ How many rows will be inserted by the SQL statement in question $4?$

Write your answer below.

$7.$ Execute the SQL statement from Question $4,$ then run 'SELECT $*$ FROM

youffistname, grocery,items;$\text{'}$ to verify your answers to Question $5$ and $6.$

Provide a screenshot of the result below.

$8.$ Which of the following statements is true about the SQL statement in Question $4?$

a$)$ 'yourfirstname new items' is the source table and 'youfirstname procery items' is the

target table.

b$)$ 'yourfirstname..grocerv. items' is the source table and 'yourfirstname. new.items' is the

target table.