user: ### NOW ANSWER:
Question: Name the total number in season for "The Battle of Evermore"
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: [104.0, 1.0, '"Going to California"', 'David Trainer', 'Jeff Filgo & Jackie Filgo', 'September17,2002', 501.0]
SQL:

assistant: SELECT COUNT("No. in season") FROM "Table" WHERE "Title" = '"The Battle of Evermore"';