SQL TRIGGER PROBLEM
Create the following inventory table and pending orders table.Insert rows as shown below into the inventory table. Pending_orderstable starts out empty but the trigger that you will write willinsert rows into the table if necessary. Qty_on_hand column showsthe current inventory, reorder_point is the level of inventory andif the level of inventory falls below this threshold an order willhave to be placed in the quantity indicated by the reorder quantityfor that part. The trigger that you will write works on theinventory table and watches the updates to this table. If theupdate to a row in the inventory table makes
OR
OR