user: ### NOW ANSWER:
Question: Who is the director when the title is listed as "All Guts, No Glory"?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: [74.0, 1.0, '"Where There\'s a Will, There\'s a Way" (Part 1)', 'Shelley Jensen', 'Gary H. Miller', 'September20,1993', 60031.0]
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "Title" = '"All Guts, No Glory"';