Table: forget_match_stats
Columns: date
tournament
surface
partnering
opponent_in_the_final
score

Question: Where was the tournament that happened in 1987 on a clay surface?
SQL: SELECT "tournament" FROM forget_match_stats WHERE "date" = 1987 AND "surface" = 'clay'

Question: Who was the opponent before 1990 that had a score of 4–6, 6–3, 6–4 and Partnering of Yannick Noah?
SQL: SELECT "opponent_in_the_final" FROM forget_match_stats WHERE "date" < 1990 AND "partnering" = 'yannick noah' AND "score" = '4–6, 6–3, 6–4'