CREATE TABLE table_55848 ("Presidency" FLOAT, "President" CLOB, "Date of Birth" CLOB, "Took office" FLOAT, "Left office" CLOB)

What is the highest Presidency that Took Office after 1974 and Left Office in 1998?
SELECT MAX("Presidency") FROM table_55848 WHERE "Left office" = '1998' AND "Took office" > '1974'
SELECT MAX("Presidency") FROM "table_55848" WHERE "Left office" = '1998' AND "Took office" > '1974'