human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Country, Rank, Aid, Trade, Investment, Migration, Environment, Security, Technology, Overall (Average)
###Question: What is the environment rating of the country with an overall average rating of 4.7?
gpt
SELECT Environment FROM table WHERE Overall (Average) = 4.7