Table schema:
CREATE TABLE Residents (other_details VARCHAR)

Question: What are the resident details containing the substring 'Miss'?
SQL: SELECT other_details FROM Residents WHERE other_details LIKE '%Miss%'