What is the highest value for 2000, when the value for 1950 is 3.5, and when the value for 1970 is greater than 3.4?
CREATE TABLE table_name_78 (Id VARCHAR)
SELECT MAX(2000) FROM table_name_78 WHERE 1950 = 3.5 AND 1970 > 3.4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (Id VARCHAR) Question: What is the highest value for 2000, when the value for 1950 is 3.5, and when the value for 1970 is greater than 3.4? [/INST] SELECT MAX(2000) FROM table_name_78 WHERE 1950 = 3.5 AND 1970 > 3.4 </s>