CREATE TABLE table_name_8 (result_f___a VARCHAR2, opponents VARCHAR2)

Which Result F-A has Opponents of rosenborg?
SELECT result_f___a FROM table_name_8 WHERE opponents = "rosenborg"
SELECT "result_f___a" FROM "table_name_8" WHERE "opponents" = "rosenborg"