Table: lingusamy_films
Columns: year
film
director
producer
writer

Question: What year is the latest year that has no under director?
SQL: SELECT MAX("year") FROM lingusamy_films WHERE "director" = 'no'

Question: With yes under writer and in 2014, what is the director?
SQL: SELECT "director" FROM lingusamy_films WHERE "year" = 2014 AND "writer" = 'yes'

Question: Who is the writer of the film Run?
SQL: SELECT "writer" FROM lingusamy_films WHERE "film" = 'run'