update salaryset sex =case when sex='m' then 'f'when sex='f' then 'm'end;

select FirstName, LastName, City, Statefrom Person left outer join Addre...