Which cities do more than one employee under age 30 come from?
CREATE TABLE employee (city VARCHAR, age INTEGER)
SELECT city FROM employee WHERE age < 30 GROUP BY city HAVING COUNT(*) > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employee (city VARCHAR, age INTEGER) Question: Which cities do more than one employee under age 30 come from? [/INST] SELECT city FROM employee WHERE age < 30 GROUP BY city HAVING COUNT(*) > 1 </s>