user: ### NOW ANSWER:
Question: What is the average heat ranked at 30?
Columns: ['Rank', 'Heat', 'Athlete', 'Country', 'Time']
Types: ['real', 'real', 'text', 'text', 'real']
Sample row: [1.0, 8.0, 'Oludamola Osayomi', 'Nigeria', 11.13]
SQL:

assistant: SELECT AVG("Heat") FROM "Table" WHERE "Rank" = 30.0;