CREATE TABLE table_20080 ("No. in season" FLOAT, "No. disc" FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "Original air date" CLOB)

How many seasons did Peter Deluise direct Stargate SG-1?
SELECT MAX("No. in season") FROM table_20080 WHERE "Directed by" = 'Peter DeLuise'
SELECT MAX("No. in season") FROM "table_20080" WHERE "Directed by" = 'Peter DeLuise'