find the name of people whose height is lower than the average.
CREATE TABLE people (name VARCHAR, height INTEGER)
SELECT name FROM people WHERE height < (SELECT AVG(height) FROM people)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE people (name VARCHAR, height INTEGER) Question: find the name of people whose height is lower than the average. [/INST] SELECT name FROM people WHERE height < (SELECT AVG(height) FROM people) </s>