CREATE TABLE table_79787 ("Team 1" CLOB, "Agg." CLOB, "Team 2" CLOB, "1st leg" CLOB, "2nd leg" CLOB)

Which teams had an aggregate score of 3-4?
SELECT "Team 1" FROM table_79787 WHERE "Agg." = '3-4'
SELECT "Team 1" FROM "table_79787" WHERE "Agg." = '3-4'