What are the resident details containing the substring 'Miss'?
select other_details from residents where other_details like '%miss%'