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