UPDATE

UPDATE table_name[ [ AS ] alias ]
  SET { column_name = { expression | DEFAULT } |
        ( column_name [, ...] ) = ( { expression | DEFAULT } [, ...] ) |
        ( column_name [, ...] ) = ( sub-SELECT )
      } [, ...]
  [ WHERE condition ]
  [ RETURNING output_expression [[ AS ] output_name ] [, ...] ]

UPDATE orders SET o_date = '2022-01-01' WHERE c_custkey = 1

UPDATE orders SET o_date = '2022-01-01', o_totalprice = O_totalprice * 0.1
WHERE o_name = 'order of John Doe1' AND o_date > '2000-01-01'
RETURNING ROWID;

UPDATE orders SET o_date = '2022-01-01'
WHERE ROWID in (12345678, 12345677, 12345676);

UPDATE orders
SET o_totalprice = (SELECT MAX(o_totalprice * 1.10) FROM old_orders)
WHERE o_date > '2022-12-12';