Find all the films longer than 100 minutes, or rated PG, except those who cost more than 200 for replacement. List the titles.
CREATE TABLE film (title VARCHAR, replacement_cost INTEGER, LENGTH VARCHAR, rating VARCHAR)
SELECT title FROM film WHERE LENGTH > 100 OR rating = 'PG' EXCEPT SELECT title FROM film WHERE replacement_cost > 200
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (title VARCHAR, replacement_cost INTEGER, LENGTH VARCHAR, rating VARCHAR) Question: Find all the films longer than 100 minutes, or rated PG, except those who cost more than 200 for replacement. List the titles. [/INST] SELECT title FROM film WHERE LENGTH > 100 OR rating = 'PG' EXCEPT SELECT title FROM film WHERE replacement_cost > 200 </s>