UPDATE(data in a table)

UPDATE .... changes the DATA within a table

Have a go at these exercise(s) for the UPDATE statement: 

UPDATE exercises (1)

update car_sales

set purchase_price = 100680

where purchase_price = 100678