CREATE TABLE table_201_25 (id NUMBER, "party" CLOB, "leader" CLOB, "from" CLOB, "to" CLOB)

how many parties had the same leader in office twice ?
SELECT COUNT(DISTINCT "party") FROM table_201_25 GROUP BY "leader" HAVING COUNT("leader") = 2
SELECT COUNT(DISTINCT "party") FROM "table_201_25" GROUP BY "leader" HAVING COUNT("leader") = 2