begin tran update authors set state = 'HI' delete publishers where state = 'CA' commit tran