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"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many episodes were directed by Rod Hardy? ### Input: CREATE TABLE table_25740548_2 (
    original_air_date VARCHAR,
    directed_by VARCHAR
) ### Response: SELECT COUNT(original_air_date) FROM table_25740548_2 WHERE directed_by = "Rod Hardy"