CREATE MATERIALIZED VIEW OrdCost AS

SELECT c$\_$custkey, sum$($o$\_$totalprice$)$

FROM ORDER, CUSTOMER

WHERE ORDER.c$\_$custkey $=$ CUSTOMER.c$\_$custkey

and o$\_$shippriority $=0$ and c$\_$acctbal $>0$

GROUP BY c$\_$custkey

Show the update needed to keep the materialized view in sync when there are insertions in ORDER

or in CUSTOMER by

$$ showing the code to create the ORDER$-$INSERTIONS table and the CUSTOMER$-$INSERTIONS

table that are needed to update the view.

$$ the code needed to update the view using these tables $($hint: this is the count algorithm$).$