user: Question: What Character has a Rank of Intelligence Officer?
Columns: ['Actor/actress', 'Character', 'Rank', 'Tenure', 'Episodes']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Rodger Corser', 'Lawson Blake', 'Senior Sergeant', '2008–2011', '01–70']
SQL:

assistant: SELECT "Character" FROM "Table" WHERE "Rank" = 'Intelligence Officer';