Reference no: EM133049415

1. We are preparing to archive old data from the Sales Orders Modify database. Before we do this, we would like to update the OrderTotal column for each order to be sure that it reflects the total of the line items in that order. Write a query to do this. (Hint: use a subquery in the SET clause to calculate the total of the line items for that order.) (933 rows)

2. Now that you have successfully archived the old orders and details, delete those rows from the original tables. As a safety precaution, be sure to include conditions that will only delete data from orders that appear in the corresponding archive table. (HINT: This solution also requires two complete transactions but you must list and execute them in the correct order.) (2456 rows, 579 rows)

3. Now that you have successfully archived the old orders and details, delete those rows from the original tables. As a safety precaution, be sure to include conditions that will only delete data from orders that appear in the corresponding archive table. (HINT: This solution also requires two complete transactions but you must list and execute them in the correct order.) (2456 rows, 579 rows)