In the context of this exercise, how is
ALTER different from
Although similar in the sense that both statements will modify a table, these statements are quite different.
The ALTER statement is used to modify columns. With
ALTER, you can add columns, remove them, or even modify them.
The UPDATE statement is used to modify rows. However,
UPDATE can only update a row, and cannot remove or add rows.