Table: city_homicide_cast
Columns: actor_actress
character
rank
tenure
episodes

Question: What rank did actor Aaron Pedersen's character have?
SQL: SELECT "rank" FROM city_homicide_cast WHERE "actor_actress" = 'aaron pedersen'

Question: What years were actress Nadine Garner on the show?
SQL: SELECT "tenure" FROM city_homicide_cast WHERE "actor_actress" = 'nadine garner'

Question: What character did actor Damien Richardson play?
SQL: SELECT "character" FROM city_homicide_cast WHERE "actor_actress" = 'damien richardson'

Question: What episode did actor Daniel Macpherson's character have the rank of Detective Senior Constable
SQL: SELECT "episodes" FROM city_homicide_cast WHERE "rank" = 'detective senior constable' AND "actor_actress" = 'daniel macpherson'