CREATE TABLE table_name_40 (team_1 VARCHAR)

What is the 1st leg that has a Rc Cannes Team 1?
SELECT 1 AS st_leg FROM table_name_40 WHERE team_1 = "rc cannes"
SELECT 1 AS "st_leg" FROM "table_name_40" WHERE "rc cannes" = "team_1"