Table: adrian_mannarino_match_stats
Columns: date
tournament
surface
opponent_in_the_final
score

Question: What is Date, when Surface is "Carpet"?
SQL: SELECT "date" FROM adrian_mannarino_match_stats WHERE "surface" = 'carpet'

Question: What is Tournament, when Date is "6 October 2008"?
SQL: SELECT "tournament" FROM adrian_mannarino_match_stats WHERE "date" = '6 october 2008'

Question: What is Surface, when Tournament is "Sunderland , United Kingdom"?
SQL: SELECT "surface" FROM adrian_mannarino_match_stats WHERE "tournament" = 'sunderland , united kingdom'