How many episodes were directed by Rod Hardy?
CREATE TABLE table_25740548_2 (original_air_date VARCHAR, directed_by VARCHAR)
SELECT COUNT(original_air_date) FROM table_25740548_2 WHERE directed_by = "Rod Hardy"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_25740548_2 (original_air_date VARCHAR, directed_by VARCHAR) Question: How many episodes were directed by Rod Hardy? [/INST] SELECT COUNT(original_air_date) FROM table_25740548_2 WHERE directed_by = "Rod Hardy" </s>