user: Question: What is the highest Presidency that Took Office after 1974 and Left Office in 1998?
Columns: ['Presidency', 'President', 'Date of Birth', 'Took office', 'Left office']
Types: ['real', 'text', 'text', 'real', 'text']
Sample row: [1.0, 'Robert Guérin', '1876', 1904.0, '1906']
SQL:

assistant: SELECT MAX("Presidency") FROM "Table" WHERE "Left office" = '1998' AND "Took office" > 1974.0;