user: ### NOW ANSWER:
Question: What is the environment rating of the country with an overall average rating of 4.7?
Columns: ['Country', 'Rank', 'Aid', 'Trade', 'Investment', 'Migration', 'Environment', 'Security', 'Technology', 'Overall (Average)']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Denmark', '11.5', '5.3', '4.7', '6.2', '6.8', '7.7', '6.6', '7.0']
SQL:

assistant: SELECT "Environment" FROM "Table" WHERE "Overall (Average)" = '4.7';