How to change surname of a student “Brown” into “Smith” whose name is “Sam”

Question

How to change surname of a student “Brown” into “Smith”  whose name is “Sam”

Answer

Update surname = ‘Smith where name = ‘Sam’;

Answer

Update student set surname = ‘Smith’ where name = ‘Sam’

Answer

Update student set surname = ‘Smith where name = ‘Sam’;

Answer

Update student set surname = ‘Brown’ where name = ‘Smith’;

Answer

Update student set surname = Smith where name = ‘Sam’;

Answer

Update surname set name = ‘Sam’ where surname = ‘Smith’;

Crowdly