user: Question: How many seasons did Peter DeLuise direct Stargate SG-1?
Columns: ['No. in season', 'No. disc', 'Title', 'Directed by', 'Written by', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 1.0, '" Redemption "', 'Martin Wood', 'Robert C. Cooper', 'June7,2002 ( Sci Fi Channel )']
SQL:

assistant: SELECT COUNT("No. in season") FROM "Table" WHERE "Directed by" = 'Peter DeLuise';