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

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