Table: lee_awards
Columns: award
category
year
title
result

Question: How many years have an Award of venice film festival, and a Title of lust, caution?
SQL: SELECT COUNT("year") FROM lee_awards WHERE "award" = 'venice film festival' AND "title" = 'lust, caution'

Question: Which Category has a Year larger than 1996, and a Result of won, and a Title of brokeback mountain, and an Award of golden globe award?
SQL: SELECT "category" FROM lee_awards WHERE "year" > 1996 AND "result" = 'won' AND "title" = 'brokeback mountain' AND "award" = 'golden globe award'

Question: Which Title has a Year smaller than 2001, and an Award of independent spirit awards?
SQL: SELECT "title" FROM lee_awards WHERE "year" < 2001 AND "award" = 'independent spirit awards'