question: How many seasons did Peter Deluise direct Stargate SG-1?
answer: SELECT MAX(no_in_season) FROM table_15431959_1 WHERE directed_by = "Peter DeLuise"
context: CREATE TABLE table_15431959_1 (no_in_season INTEGER, directed_by VARCHAR)