CREATE TABLE table_name_6 (team_1 VARCHAR2)

Team 1, Everton, has what as a 1st leg?
SELECT 1 AS st_leg FROM table_name_6 WHERE team_1 = "everton"
SELECT 1 AS "st_leg" FROM "table_name_6" WHERE "everton" = "team_1"