Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
Name the total number of r for josh thompson

### Inputs:
table_name: table, columns: ['R', 'Player', 'Scottish Premier League', 'Scottish Cup', 'Scottish League Cup', 'Champions League (qualifying)', 'Europa League', 'Total']

### Response:
SELECT COUNT R FROM table WHERE Player = Josh Thompson