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

Which 1st leg has a Team 1 of drita?
SELECT "1st leg" FROM table_45990 WHERE "Team 1" = 'drita'
SELECT "1st leg" FROM "table_45990" WHERE "Team 1" = 'drita'