Table: robert earnshaw
[['date', 'venue', 'score', 'result', 'competition'], ['14 may 2002', 'millennium stadium , cardiff , wales', '1 - 0', '1 - 0', 'friendly'], ['12 february 2003', 'millennium stadium , cardiff , wales', '1 - 0', '2 - 2', 'friendly'], ['11 october 2003', 'millennium stadium , cardiff , wales', '2 - 3', '2 - 3', 'uefa euro 2004 qual'], ['18 february 2004', 'millennium stadium , cardiff , wales', '1 - 0', '4 - 0', 'friendly'], ['18 february 2004', 'millennium stadium , cardiff , wales', '2 - 0', '4 - 0', 'friendly'], ['18 february 2004', 'millennium stadium , cardiff , wales', '3 - 0', '4 - 0', 'friendly'], ['31 march 2004', 'stadium puskás ferenc , budapest , hungary', '1 - 2', '1 - 2', 'friendly'], ['8 september 2004', 'millennium stadium , cardiff , wales', '2 - 2', '2 - 2', '2006 fifa world cup qual'], ['13 october 2004', 'millennium stadium , cardiff , wales', '1 - 0', '2 - 3', '2006 fifa world cup qual'], ['27 may 2006', 'upc - arena , graz , austria', '1 - 1', '1 - 2', 'friendly'], ['27 may 2006', 'upc - arena , graz , austria', '1 - 2', '1 - 2', 'friendly'], ['11 october 2006', 'millennium stadium , cardiff , wales', '2 - 0', '3 - 1', 'uefa euro 2008 qual'], ['17 october 2007', 'stadio olimpico , serravalle , san marino', '1 - 0', '1 - 2', 'uefa euro 2008 qual'], ['29 may 2009', 'parc y scarlets , llanelli , wales', '1 - 0', '1 - 0', 'friendly'], ['25 may 2011', 'aviva stadium , dublin , ireland', '1 - 0', '1 - 3', '2011 nations cup'], ['27 may 2011', 'aviva stadium , dublin , ireland', '2 - 0', '2 - 0', '2011 nations cup']]
Statement: 1 - 0 was both the Score and Result on 14 May 2002 and on 29 May 2009
Statement: 4 - 0 was the highest Result and it was for 3 game
Statement: the Competition was 2006 Fifa World Cup Qual on 8 September 2004 and on 13 October 2004
Statement: Millennium Stadium , Cardiff , Wales was the Venue in 9 of Robert Earnshaw 's game
Statement: Stadio Olimpico , Serravalle , San Marino was the Venue 6 day after the game in Millennium Stadium , Cardiff , Wale on 11 October 2006