What are all the movies rated as R? List the titles.
CREATE TABLE film (title VARCHAR, rating VARCHAR)
SELECT title FROM film WHERE rating = 'R'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (title VARCHAR, rating VARCHAR) Question: What are all the movies rated as R? List the titles. [/INST] SELECT title FROM film WHERE rating = 'R' </s>