Reference no: EM133048618

-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)

-We would like to archive any orders that were placed and fulfilled before 2018. Write the SQL statements needed to copy all orders that were placed before January 1, 2018 and their line-item details to the corresponding archive tables. Remember to copy order information only for orders that were also shipped before January 1, 2018. (HINT: This solution requires two complete transactions.) (579 rows, 2456 rows)

-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)