DB Problems

1.Find all movies where the special features are not listed (i.e., special_features is NULL). SELECT title FROM film WHERE special features = NULL; Meaning : It returns the title of the movie where the special feature is null 2.Find all movies where the rental duration is more than 7 days. SELECT title , rental FROM film WHERE rental_duration > 7; Meaning : It returns the title of the movie and rental_duration more than 7 days 3.Find all movies that have a rental rate of $4.99 and a replacement cost of more than $20 SELECT title , rental_rate , replacement_cost FROM film WHERE rental_rate = 4.99 AND replacement_cost > 20; Meaning : It returns the title of the movie , rental_rate is equal to 4.99 and replacement_cost more than 20 4.Find all movies that have a rental rate of $0.99 or a rating of 'PG-13'. SELECT title , rental_rate , rating FROM film WHERE rental_rate = 0.99 OR rating = 'PG-13'; Meaning : It returns title , rental_rate with 0.99 and rating with PG-13 5.Retrieve the first