Table: mysterious_ways_episodes
Columns: series
season
title
director
writer_s
nbc_airdate
code

Question: What is the latest season number that Eric Tuchman directed? 
SQL: SELECT MAX("season") FROM mysterious_ways_episodes WHERE "director" = 'Eric Tuchman'

Question: How man seasons have the air date of October 2, 2001? 
SQL: SELECT COUNT("season") FROM mysterious_ways_episodes WHERE "nbc_airdate" = 'October 2, 2001'

Question: Who wrote, "The Last Dance"?
SQL: SELECT "writer_s" FROM mysterious_ways_episodes WHERE "title" = '"The Last Dance"'