user: ### NOW ANSWER:
Question: What was the season number episode directed by John David Coles?
Columns: ['Season no.', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. Viewers (millions)']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, '" One "', 'Jean de Segonzac', 'Teleplay by: Rene Balcer Story by: Dick Wolf', 'September30,2001', 'E2101', '12.80']
SQL:

assistant: SELECT "Season no." FROM "Table" WHERE "Directed by" = 'John David Coles';