What Character has a Rank of intelligence officer?
CREATE TABLE table_13070 (
    "Actor/actress" text,
    "Character" text,
    "Rank" text,
    "Tenure" text,
    "Episodes" text
)
SELECT "Character" FROM table_13070 WHERE "Rank" = 'intelligence officer'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What Character has a Rank of intelligence officer? ### Input: CREATE TABLE table_13070 (
    "Actor/actress" text,
    "Character" text,
    "Rank" text,
    "Tenure" text,
    "Episodes" text
) ### Response: SELECT "Character" FROM table_13070 WHERE "Rank" = 'intelligence officer'