Task: Text to Code
Input (English): find the date_moved_in of Residents table with smallest value of date_moved_out
Output (English): SELECT date_moved_in FROM Residents ORDER BY date_moved_out Asc LIMIT 1