Task: Text to Code
Input (English): What is the average number of gold medals for clubs?
Output (English): SELECT avg(Gold) FROM club_rank