user: Question: Which number episode of season 6 was the title "Sight Unseen"?
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 "No. in season" FROM "Table" WHERE "Title" = '"Sight Unseen"';