CREATE TABLE table_13070 ("Actor/actress" TEXT, "Character" TEXT, "Rank" TEXT, "Tenure" TEXT, "Episodes" TEXT)

What Character has a Rank of intelligence officer?
SELECT "Character" FROM table_13070 WHERE "Rank" = 'intelligence officer'
SELECT "Character" FROM "table_13070" WHERE "Rank" = 'intelligence officer'