question: What was the season number episode directed by John David Coles?
answer: SELECT season_no FROM table_21781578_2 WHERE directed_by = "John David Coles"
context: CREATE TABLE table_21781578_2 (season_no VARCHAR, directed_by VARCHAR)