Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
7. Exercise 3


Good job! Let's keep going.


A mistake has crept into the database. The adoptive person Gary Thomas (Id = 3) has the FirstName value N'Thomas' and the LastName value N'Gary'.

Correct this and print the previous last name (name the column LastNameBefore) and the updated last name (name the column LastNameAfter). Use an UPDATE operation.
Recall that the name of the relevant table is AdoptivePerson.