CREATE TABLE table_201_25 (id DECIMAL, "party" TEXT, "leader" TEXT, "from" TEXT, "to" TEXT)

which party had its first leader in 1974 and last leader in 1980 ?
SELECT "party" FROM table_201_25 GROUP BY "party" HAVING MIN("from") = 1974 AND MAX("to") = 1980
SELECT "party" FROM "table_201_25" GROUP BY "party" HAVING MAX("to") = 1980 AND MIN("from") = 1974