Task: Text to Code
Input (English): What is the total number of clubs that have less than 10 medals in total?
Output (English): SELECT count(*) FROM club_rank WHERE Total  <  10