What are the resident details containing the substring 'Miss'?
create table residents (other_details varchar, PRIMARY KEY (other_details))
select other_details from residents where other_details like '%miss%'