CREATE TABLE table_25019 ("State  ( class ) " CLOB, "Vacator" CLOB, "Reason for change" CLOB, "Successor" CLOB, "Date of successors formal installation" CLOB)

how many times has Aaron Ogden (f), been a successor and has had a formal installation?
SELECT COUNT("Date of successors formal installation") FROM table_25019 WHERE "Successor" = 'Aaron Ogden (F)'
SELECT COUNT("Date of successors formal installation") FROM "table_25019" WHERE "Successor" = 'Aaron Ogden (F)'