Psst! Check what courses we have in our offer, and get them all here to save $727. Tick-tock—this deal ends on 3/21.
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.