$7-$ Suppose you have a database schema below.

Orders $($orderld$,$ totalSales$)$

Order$\_$items $($orderltemld$,$ orderld, itemPrice$)$

Write a MySQL trigger to automatically update the totalSales column in the Orders table whenever a new row is inserted into the Order$\_$items table. The Order$\_$items table contains the orderld $($foreign key referencing Orders table$)$ and itemPrice columns. $(20$ pts$.)$