CREATE TABLE table_22977424_8 (name VARCHAR2, promoted_to_league VARCHAR2)

Name the name for plymouth albion orrell
SELECT name FROM table_22977424_8 WHERE promoted_to_league = "Plymouth Albion Orrell"
SELECT "name" FROM "table_22977424_8" WHERE "Plymouth Albion Orrell" = "promoted_to_league"