How many students have personal names that contain the word "son"?
CREATE TABLE Students (personal_name VARCHAR)
SELECT COUNT(*) FROM Students WHERE personal_name LIKE "%son%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Students (personal_name VARCHAR) Question: How many students have personal names that contain the word "son"? [/INST] SELECT COUNT(*) FROM Students WHERE personal_name LIKE "%son%" </s>