Staff of

select * from staff order by field(desig, 'Professor', 'Associate Professor','Assistant Professor')