CREATE TABLE table_201_10 (id NUMBER, "#" NUMBER, "name" CLOB, "office" CLOB, "political party" CLOB, "occupation" CLOB)

how many mayors were in office for a total of 9 years ?
SELECT COUNT("name") FROM table_201_10 WHERE "office" - "office" = 9
SELECT COUNT("name") FROM "table_201_10" WHERE "office" - "office" = 9