Table: film_1997
Columns: rank
title
studio
director
worldwide_gross

Question: what is the title when the rank is less than 17 and the worldwide gross is $299,288,605?
SQL: SELECT "title" FROM film_1997 WHERE "rank" < 17 AND "worldwide_gross" = '$299,288,605'

Question: what is the highest rank for director john woo?
SQL: SELECT MAX("rank") FROM film_1997 WHERE "director" = 'john woo'

Question: what is the title for director p.j. hogan?
SQL: SELECT "title" FROM film_1997 WHERE "director" = 'p.j. hogan'