Table: big_time_rush_characters
Columns: character
played_by
season_1
season_2
season_3
season_4
first_appearance

Question: How many season 4 appearances are there by Mrs. Jennifer Knight?
SQL: SELECT MIN("season_4") FROM big_time_rush_characters WHERE "character" = 'Mrs. Jennifer Knight'

Question: How many season 3 appearances by Morgan the Dog?
SQL: SELECT MAX("season_3") FROM big_time_rush_characters WHERE "played_by" = 'Morgan the Dog'

Question: What episode was the first appearance of the character who appears 7 times in season 4?
SQL: SELECT "first_appearance" FROM big_time_rush_characters WHERE "season_4" = 7

Question: How many season 3 appearances by the character played by Stefan Van Ray?
SQL: SELECT MIN("season_3") FROM big_time_rush_characters WHERE "played_by" = 'Stefan van Ray'

Question: What is the first appearance of the character played by Obdul Reid?
SQL: SELECT "first_appearance" FROM big_time_rush_characters WHERE "played_by" = 'Obdul Reid'