What rank Nation that have fewer than 24 total medal more than 7 Gold medal?
Rank Nation Gold Silver Bronze Total
Athletics at the 1935 Central American and Caribbean Games
10102961
real text real real real real
2-10102961-2
Medal table
Medal table
1 Cuba 8 9 7 24
2 Mexico 7 6 8 21
3 Puerto Rico 4 4 3 11
4 Guatemala 1 1 1 3
5 Panama 0 0 1 1
SELECT AVG Rank FROM table WHERE Total < 24 AND Gold > 7
24 7