human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Country, Name, Host, Channel, Prize, First year aired
###Question: What year did Zone Rouge first air?
gpt
SELECT First year aired FROM table WHERE Name = zone rouge