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

What is the 1st leg that has a Rc Cannes Team 1?
SELECT "1st leg" FROM table_59269 WHERE "Team 1" = 'rc cannes'
SELECT "1st leg" FROM "table_59269" WHERE "Team 1" = 'rc cannes'