32 - Filter Assignments

Movies where special_features is NULL SELECT * FROM film WHERE special_features IS NULL; Movies where rental duration > 7 days SELECT * FROM film WHERE rental_duration > 7; Movies with rental rate = 4.99 and replacement cost > 20 SELECT * FROM film WHERE rental_rate = 4.99 AND replacement_cost > 20; Movies with rental rate = 0.99 OR rating = 'PG-13' SELECT * FROM film WHERE rental_rate = 0.99 OR rating = 'PG-13'; First 5 movies sorted by title SELECT * FROM film ORDER BY title ASC LIMIT 5; Skip first 10, get next 3 highest replacement cost SELECT * FROM film ORDER BY replacement_cost DESC LIMIT 3 OFFSET 10; Movies with rating G, PG, PG-13 SELECT * FROM film WHERE rating IN ('G', 'PG', 'PG-13'); Movies with rental rate between 2 and 4 SELECT * FROM film WHERE rental_rate BETWEEN 2 AND 4; Movies with title starting with 'The' SELECT * FROM film WHERE title LIKE 'The%'; First 10 movies with conditions SELECT * FROM film WHERE rental_rate IN (2.99, 4.99) AND rating = 'R' AND title LIKE '%L