Table schema:
CREATE TABLE table_name_47 (time VARCHAR, rank VARCHAR)

Question: What is the time of the swimmer in rank 40?
SQL: SELECT time FROM table_name_47 WHERE rank = 40