Table: fifa_presidents
Columns: presidency
president
date_of_birth
took_office
left_office

Question: What President has a Presidency greater than 7?
SQL: SELECT "president" FROM fifa_presidents WHERE "presidency" > 7

Question: What is the highest Presidency that Took Office after 1974 and Left Office in 1998?
SQL: SELECT MAX("presidency") FROM fifa_presidents WHERE "left_office" = '1998' AND "took_office" > 1974

Question: What is the Took Office Date of the Presidency that Left Office Incumbent?
SQL: SELECT SUM("took_office") FROM fifa_presidents WHERE "left_office" = 'incumbent'

Question: What was the greatest Took Office dates that Left Office in 1998?
SQL: SELECT MAX("took_office") FROM fifa_presidents WHERE "left_office" = '1998'