Find the average age of students who do not have any pet .
CREATE TABLE student (age INTEGER, stuid VARCHAR); CREATE TABLE has_pet (age INTEGER, stuid VARCHAR)
SELECT AVG(age) FROM student WHERE NOT stuid IN (SELECT stuid FROM has_pet)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE student (age INTEGER, stuid VARCHAR); CREATE TABLE has_pet (age INTEGER, stuid VARCHAR) Question: Find the average age of students who do not have any pet . [/INST] SELECT AVG(age) FROM student WHERE NOT stuid IN (SELECT stuid FROM has_pet) </s>