Tell me the number of dogs that have not received any treatment .
CREATE TABLE treatments (dog_id VARCHAR); CREATE TABLE dogs (dog_id VARCHAR)
SELECT COUNT(*) FROM dogs WHERE NOT dog_id IN (SELECT dog_id FROM treatments)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE treatments (dog_id VARCHAR); CREATE TABLE dogs (dog_id VARCHAR) Question: Tell me the number of dogs that have not received any treatment . [/INST] SELECT COUNT(*) FROM dogs WHERE NOT dog_id IN (SELECT dog_id FROM treatments) </s>