Table: loit_tournament_stats
Columns: date
tournament
surface
opponent_in_the_final
score

Question: what is the date for the tournament acapulco?
SQL: SELECT "date" FROM loit_tournament_stats WHERE "tournament" = 'acapulco'

Question: who is the opponent in the final when the tournament is cagnes-sur-mer?
SQL: SELECT "opponent_in_the_final" FROM loit_tournament_stats WHERE "tournament" = 'cagnes-sur-mer'

Question: what is the date for the tournament joué-lès-tours?
SQL: SELECT "date" FROM loit_tournament_stats WHERE "tournament" = 'joué-lès-tours'

Question: what is the score for the tournament cagnes-sur-mer?
SQL: SELECT "score" FROM loit_tournament_stats WHERE "tournament" = 'cagnes-sur-mer'

Question: what is the score on may 11, 1997?
SQL: SELECT "score" FROM loit_tournament_stats WHERE "date" = 'may 11, 1997'