CREATE TABLE table_203_345 (id DECIMAL, "name" TEXT, "party" TEXT, "took office" DECIMAL, "left office" DECIMAL)

which progressive party member took office after a liberal ?
SELECT "name" FROM table_203_345 WHERE "party" = 'progressive' AND id = (SELECT id FROM table_203_345 WHERE "party" = 'liberal') + 1
SELECT "name" FROM "table_203_345" WHERE "id" = (SELECT "id" FROM "table_203_345" WHERE "party" = 'liberal') + 1 AND "party" = 'progressive'