Create Views, Insert, and Update Correctly

(a) View for trailing 7-day completed spend If only the underlying SELECT is required, use the same query without the CREATE VIEW wrapper. (b) Insert new product and order (c) Update order 1002 to completed (d) Apply 10% price reduction and return view rows Expected result after the update: Yes, the totals change. The view is a regular view, so it joins directly to the current products table. Once WidgetB is reduced from 50.00 to 45.00, all completed orders in the window…