CREATE TABLE table_203_420 (id NUMBER, "#" NUMBER, "stadium" CLOB, "capacity" NUMBER, "city" CLOB, "home team" CLOB)

which stadium can hold more people than ballymena showgrounds , but less than windsor park ?
SELECT "stadium" FROM table_203_420 WHERE "capacity" > (SELECT "capacity" FROM table_203_420 WHERE "stadium" = 'ballymena showgrounds') AND "capacity" < (SELECT "capacity" FROM table_203_420 WHERE "stadium" = 'windsor park')
SELECT "stadium" FROM "table_203_420" WHERE "capacity" < (SELECT "capacity" FROM "table_203_420" WHERE "stadium" = 'windsor park') AND "capacity" > (SELECT "capacity" FROM "table_203_420" WHERE "stadium" = 'ballymena showgrounds')