CA 32 - Filter Assignments

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

2. Movies with rental duration > 7 days:-
   SELECT *FROM film WHERE rental_duration > 7;

3. Rental rate = 4.99 AND replacement cost > 20
   SELECT *FROM film WHERE rental_rate = 4.99 AND replacement_cost > 20;

4. 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 alphabetically:-
   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 OFFSET 10 LIMIT 3;

7. Rating in ('G', 'PG', 'PG-13'):-
   SELECT * FROM film WHERE rating IN ('G', 'PG', 'PG-13');

8. Rental rate between 2 and 4:-
   SELECT * FROM film WHERE rental_rate BETWEEN 2 AND 4;

9. Titles starting with "The":-
   SELECT * FROM film WHERE title LIKE 'The%';

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

11. Titles containing %:-
    SELECT *FROM film WHERE title LIKE '%\%%' ESCAPE '\';

12. Titles containing _
    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%s' OR title LIKE 'B%s');

14. Titles containing Man, Men, or Woman:-
    SELECT * FROM film WHERE title ILIKE '%Man%' OR title ILIKE '%Men%' OR title ILIKE '%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 ILIKE '%Love%'
    OR title ILIKE '%Hate%';

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