Filter Assignments - CA32

My Thinking and Approach Introduction In this bonus task, I explored advanced filtering techniques in SQL using the dvdrental database. The focus was on using conditions like NULL checks, pattern matching, ranges, and logical operators. This helped me understand how to extract specific and meaningful data from a database. Problem Statement Retrieve data using conditions Use operators like AND, OR, BETWEEN, IN Apply pattern matching using LIKE Work with LIMIT and OFFSET My Initial Thought At first, I thought: Filtering is just using WHERE clause Conditions are simple But I realized: SQL provides many ways to filter data Pattern matching is very powerful Combining conditions gives precise results Key Observation NULL values require special handling LIKE is used for pattern matching BETWEEN is useful for ranges LIMIT and OFFSET control output size Solutions 1. Movies with NULL special features SELECT * FROM film WHERE special_features IS NULL ; 2. Movies with rental duration more than 7 S