CREATE TABLE table_name_96 (lifespan VARCHAR2, party VARCHAR2, state VARCHAR2, representative VARCHAR2)

What is the lifespan of Joseph Vance, a democratic-republican from Ohio?
SELECT lifespan FROM table_name_96 WHERE state = "ohio" AND representative = "joseph vance" AND party = "democratic-republican"
SELECT "lifespan" FROM "table_name_96" WHERE "democratic-republican" = "party" AND "joseph vance" = "representative" AND "ohio" = "state"