What is the mean year of marriage when her age was more than 19 and his age was 30?
CREATE TABLE table_name_6 (year_of_marriage INTEGER, her_age VARCHAR, his_age VARCHAR)
SELECT AVG(year_of_marriage) FROM table_name_6 WHERE her_age > 19 AND his_age = 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (year_of_marriage INTEGER, her_age VARCHAR, his_age VARCHAR) Question: What is the mean year of marriage when her age was more than 19 and his age was 30? [/INST] SELECT AVG(year_of_marriage) FROM table_name_6 WHERE her_age > 19 AND his_age = 30 </s>