human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Rank, Player, Country, Earnings( $ ), Wins
###Question: How many players named bob charles with earnings over $7,646,958?
gpt
SELECT COUNT Rank FROM table WHERE Player = bob charles AND Earnings( $ ) > 7,646,958