What does the following SQL statement do$?$

UPDATE INSTRUCTOR SET LASTNAME $=$ 'Brewster' WHERE LASTNAME $=$ 'Smith'

$1$ point

Changes all rows for the instructor with a last name of Smith to have a last name of Brewster.

Change the row for the instructor with a last name of Brewster to have a last name of Smith.

Change all rows in the table to have a last name of Smith.

Change all rows in the table to have a last name of Brewster.