user: ### NOW ANSWER:
Question: Name the total number of r for Josh Thompson
Columns: ['R', 'Player', 'Scottish Premier League', 'Scottish Cup', 'Scottish League Cup', 'Champions League (qualifying)', 'Europa League', 'Total']
Types: ['real', 'text', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1.0, 'Robbie Keane', 12.0, 0.0, 4.0, 0.0, 0.0, 16.0]
SQL:

assistant: SELECT COUNT("R") FROM "Table" WHERE "Player" = 'Josh Thompson';