user: Question: What is the latest year for first elected with John Hostettler as incumbent and a result of Lost re-election Democratic gain?
Columns: ['District', 'Incumbent', 'Party', 'First elected', 'Results']
Types: ['text', 'text', 'text', 'real', 'text']
Sample row: ['Indiana 1', 'Pete Visclosky', 'Democratic', 1984.0, 'Re-elected']
SQL:

assistant: SELECT MAX("First elected") FROM "Table" WHERE "Results" = 'Lost re-election Democratic gain' AND "Incumbent" = 'John Hostettler';