UPDATE example
The following command updates that YTD sales to zero for each customer that was contacted in the previous calendar year:
UPDATE CUSTOMER SET YTD_SALES = 0 WHERE FIRST_CONT < '01/01/95'