Table: rush_cast
Columns: actor_actress
character
rank
tenure
episodes

Question: What is Character Kerry Vincent's Tenure?
SQL: SELECT "tenure" FROM rush_cast WHERE "character" = 'kerry vincent'

Question: What Rodger Corser Episode has a Rank of senior sergeant?
SQL: SELECT "episodes" FROM rush_cast WHERE "rank" = 'senior sergeant' AND "actor_actress" = 'rodger corser'

Question: What Character has a Rank of intelligence officer?
SQL: SELECT "character" FROM rush_cast WHERE "rank" = 'intelligence officer'

Question: What is the Rank of the Character with Tenure of 2011?
SQL: SELECT "rank" FROM rush_cast WHERE "tenure" = '2011'

Question: What Actor/Actress a Tenure of 2008–2011 played Stella Dagostino?
SQL: SELECT "actor_actress" FROM rush_cast WHERE "tenure" = '2008–2011' AND "character" = 'stella dagostino'

Question: What is Jolene Anderson's Rank?
SQL: SELECT "rank" FROM rush_cast WHERE "actor_actress" = 'jolene anderson'