SQL

http://dbgroup.cdm.depaul.edu/CSC355_Fall2018/FinalProjectData.zip

B. You are tasked with tracking the total price of all orders for each customer. Fortunately, someone previously added the column C_TotalOrderPrice column to the customer table. However, one of our employees spends 2 hours each day manually updating these entries. Rather than have someone manually update these values, we want to streamline our business, and automatically update this value.

Q.PI.B1. Write a trigger that updates the C_TotalOrderPrice column in the customer table each time a new order is added, updated, or deleted from the LINEORDER table.