/* With three tables as defined below: */ CREATE TABLE Customer (CustomerID VARCHAR (20) PRIMARY KEY, CustomerLName VARCHAR (30) , CustomerFName VARCHAR (30) , CustomerStatus VARCHAR(10) ) ; CREATE TABLE SaleOrder (Order ID INT IDENTITY PRIMARY KEY, CustomerID VARCHAR(20 ) REFERENCES Customer (CustomerID) , OrderDate DATE, Order AmountBe fore Tax INT) ; CREATE TABLE SaleOrderDetail (Order ID INT REFERENCES SaleOrder (OrderID) , ProductID INT, Quantity INT, UnitPrice INT, PRIMARY KEY (OrderID, ProductID) ) ; /* Write a trigger to update the CustomerStatus column of Customer based on the total of OrderAmountBeforeTax for all orders placed by the customer. If the total exceeds 5, 000, put Preferred in the CustomerStatus column. */