CREATE TABLE table_201_10 (id DECIMAL, "#" DECIMAL, "name" TEXT, "office" TEXT, "political party" TEXT, "occupation" TEXT)

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