Table: tennis_stats
Columns: outcome
year
championship
surface
partner
opponents_in_the_final
score_in_the_final

Question: What was the score in the final where one of the opponents in the final was fitzgerald vilas?
SQL: SELECT "score_in_the_final" FROM tennis_stats WHERE "opponents_in_the_final" = 'Fitzgerald Vilas'

Question: What was the surface for the  opponents in the final with fitzgerald vilas?
SQL: SELECT "surface" FROM tennis_stats WHERE "opponents_in_the_final" = 'Fitzgerald Vilas'

Question: Who were the opponents in the final where the score in the final is 6–4, 7–6 2?
SQL: SELECT "opponents_in_the_final" FROM tennis_stats WHERE "score_in_the_final" = '6–4, 7–6 2'

Question: What was the partner count when the opponents in the final was forget leconte?
SQL: SELECT COUNT("partner") FROM tennis_stats WHERE "opponents_in_the_final" = 'Forget Leconte'

Question: What was the year date when one of the opponents in the final was bahrami leconte and score in the final is 7–6 2 , 6–1?
SQL: SELECT MIN("year") FROM tennis_stats WHERE "opponents_in_the_final" = 'Bahrami Leconte' AND "score_in_the_final" = '7–6 2 , 6–1'