SELECT "Singapore Gross" FROM table_40916 WHERE "Title" = '1997'
For the film titled 1997, what was the gross in Singapore?
CREATE TABLE table_40916 (
    "Title" text,
    "Director" text,
    "Producer" text,
    "Production Cost" text,
    "Singapore Gross" text
)