$22-$Write SQL commands for the following:

Time left $1$:$19$:$08$

List all details from Supplier Table for all suppliers that produce Metal products.$(3$ points$)$

Update table suppliers table to change product with id $109$ product to medium table.$(3$ points$)$

Find the Supplier Name, Agent name, product name and inventory for products that are made from

plastic. $(4$ points$)$

Retrieve records of supplier that use have the string "Inc" in the supplier's name. $(3$ points$)$

Write $p\frac{l}{s}ql$ code to trigger a message if the inventory value is changed, if the agent name is changed

and if any new value is added the trigger should print a message that indicates that what value was

changed. $(4$ points$)$

write $p\frac{l}{s}ql$ code to find the sum of all products shipped by land and products shipped by sea and

prints the output as

total products shipped by land $=***********$

total products shipped by sea $=*********$

$.(4$ points$)$

Using JDBC write a Java Application that deletes the record in products table with product id $=102.(4$

points$)$