user: Question: Tell me the sum of earnings for rank less than 1
Columns: ['Rank', 'Player', 'Country', 'Earnings( $ )', 'Wins']
Types: ['real', 'text', 'text', 'real', 'real']
Sample row: [1.0, 'Bob Charles', 'New Zealand', 2494732.0, 15.0]
SQL:

assistant: SELECT SUM("Earnings( $ )") FROM "Table" WHERE "Rank" < 1.0;