select name, category, salary where category = 'permanent' order by salary desc
union all
select name, category, salary where category = 'contract' order by salary desc