CREATE TABLE Residents (other_details VARCHAR)

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