32 - Filter Assignments

1. Movies where special_features is NULL
   SELECT * FROM film
   WHERE special_features IS NULL;

2. Movies where rental duration > 7 days
   SELECT * FROM film
   WHERE rental_duration > 7;

3. Movies with rental rate = 4.99 and replacement cost > 20
   SELECT * FROM film
   WHERE rental_rate = 4.99
   AND replacement_cost > 20;

4. Movies with rental rate = 0.99 OR rating = 'PG-13'
   SELECT * FROM film
   WHERE rental_rate = 0.99
   OR rating = 'PG-13';

5. First 5 movies sorted by title
   SELECT * FROM film
   ORDER BY title ASC
   LIMIT 5;

6. Skip first 10, get next 3 highest replacement cost
   SELECT * FROM film
   ORDER BY replacement_cost DESC
   LIMIT 3 OFFSET 10;

7. Movies with rating G, PG, PG-13
   SELECT * FROM film
   WHERE rating IN ('G', 'PG', 'PG-13');

8. Movies with rental rate between 2 and 4
   SELECT * FROM film
   WHERE rental_rate BETWEEN 2 AND 4;

9. Movies with title starting with 'The'
   SELECT * FROM film
   WHERE title LIKE 'The%';

10. First 10 movies with conditions
    SELECT * FROM film
    WHERE rental_rate IN (2.99, 4.99)
    AND rating = 'R'
    AND title LIKE '%Love%'
    LIMIT 10;

11. Movies where title contains %
    SELECT * FROM film
    WHERE title LIKE '%\%%' ESCAPE '\';

12. Movies where title contains _
    SELECT * FROM film
    WHERE title LIKE '%_%' ESCAPE '\';

13. Titles start with A or B and end with s
    SELECT * FROM film
    WHERE (title LIKE 'A%' OR title LIKE 'B%')
    AND title LIKE '%s';

14. Titles containing Man, Men, or Woman
    SELECT * FROM film
    WHERE title LIKE '%Man%'
    OR title LIKE '%Men%'
    OR title LIKE '%Woman%';

15. Titles containing digits
    SELECT * FROM film
    WHERE title ~ '[0-9]';

16. Titles containing backslash ()
    SELECT * FROM film
    WHERE title LIKE '%\%';

17. Titles containing Love or Hate
    SELECT * FROM film
    WHERE title LIKE '%Love%'
    OR title LIKE '%Hate%';

18. First 5 movies ending with er, or, ar
    SELECT * FROM film
    WHERE title LIKE '%er'
    OR title LIKE '%or'
    OR title LIKE '%ar'
    LIMIT 5;