user: ### NOW ANSWER:
Question: What is the transmission when the production was 2002-2005?
Columns: ['Engine', 'Production', 'Transmission', 'Power', 'Torque', 'Acceleration 0–100km/h (0–62mph)', 'Top Speed']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1.6L', '2002-2006', '5-speed manual', 'PS (kW; bhp)', 'N·m (lb·ft)', '11.6 s', 'km/h (mph)']
SQL:

assistant: SELECT "Transmission" FROM "Table" WHERE "Production" = '2002-2005';