user: Question: what number is the episode "There Will Be Bad Blood" in the series?
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [97.0, 1.0, '"100 A.D." (Part 1)', 'Tim Parsons', 'Keith Heisler', 'October3,2010', '5AJN14', '6.16']
SQL:

assistant: SELECT "No. in series" FROM "Table" WHERE "Title" = '"There Will Be Bad Blood"';