-- Database schema
| divisions : division [ TEXT ] primary_key , name [ TEXT ] , country [ TEXT ] | matchs : Div [ TEXT ] matchs.Div = divisions.division , Date [ DATE ] , HomeTeam [ TEXT ] , AwayTeam [ TEXT ] , FTHG [ INTEGER ] , FTAG [ INTEGER ] , FTR [ TEXT ] , season [ INTEGER ] |
-- -- Of all the teams that played as a team away against Caen in the 2010 season, which one has the highest winning percentage?

SELECT AwayTeam FROM matchs WHERE HomeTeam = 'Caen' AND season = 2010 AND FTR = 'A' GROUP BY AwayTeam ORDER BY COUNT(AwayTeam) DESC LIMIT 1;