What is the 1st leg that has a Rc Cannes Team 1?
CREATE TABLE table_name_40 (team_1 VARCHAR)
SELECT 1 AS st_leg FROM table_name_40 WHERE team_1 = "rc cannes"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (team_1 VARCHAR) Question: What is the 1st leg that has a Rc Cannes Team 1? [/INST] SELECT 1 AS st_leg FROM table_name_40 WHERE team_1 = "rc cannes" </s>