What was the percentage in 2006 that had less than 9% in 1970?
CREATE TABLE table_name_47 (Id VARCHAR)
SELECT AVG(2006) FROM table_name_47 WHERE 1970 < 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (Id VARCHAR) Question: What was the percentage in 2006 that had less than 9% in 1970? [/INST] SELECT AVG(2006) FROM table_name_47 WHERE 1970 < 9 </s>