CREATE TABLE table_name_41 (constituency VARCHAR, candidate VARCHAR, position VARCHAR, party VARCHAR, election VARCHAR)

Which Alliance Constituency has Seamus Close, position 2 and an election smaller than 1997?
SELECT constituency FROM table_name_41 WHERE party = "alliance" AND election < 1997 AND position = 2 AND candidate = "seamus close"
SELECT "constituency" FROM "table_name_41" WHERE "alliance" = "party" AND "candidate" = "seamus close" AND "election" < 1997 AND "position" = 2