CREATE TABLE table_name_17 (competition VARCHAR2, opponents VARCHAR2)

Name the competition for motherwell opponents
SELECT competition FROM table_name_17 WHERE opponents = "motherwell"
SELECT "competition" FROM "table_name_17" WHERE "motherwell" = "opponents"