user: ### NOW ANSWER:
Question: How many players named bob charles with earnings over $7646958?
Columns: ['Rank', 'Player', 'Country', 'Earnings( $ )', 'Wins']
Types: ['real', 'text', 'text', 'real', 'real']
Sample row: [1.0, 'Jim Colbert', 'United States', 8249210.0, 19.0]
SQL:

assistant: SELECT COUNT("Rank") FROM "Table" WHERE "Player" = 'bob charles' AND "Earnings( $ )" > 7646958.0;