Order the resident list alphabetically by other details.
select * from residents order by other_details
How many residents have the title of 'Prof'?
select count(*) from residents where other_details like '%prof.%'
Alright, what about 'Miss'?
select other_details from residents where other_details like '%miss%'