How many films have the word 'Dummy' in their titles?
CREATE TABLE film (title VARCHAR)
SELECT COUNT(*) FROM film WHERE title LIKE "%Dummy%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (title VARCHAR) Question: How many films have the word 'Dummy' in their titles? [/INST] SELECT COUNT(*) FROM film WHERE title LIKE "%Dummy%" </s>