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: In total, how much did the United States player George Archer earn with Wins lower than 24 and a rank that was higher than 5?
gpt
SELECT COUNT Earnings( $ ) FROM table WHERE Country = united states AND Wins < 24 AND Player = george archer AND Rank > 5