Task: Text to Code
Input (English): What are the resident details containing the substring 'Miss'?
Output (English): SELECT other_details FROM Residents WHERE other_details LIKE '%Miss%'