-- select * from film;
-- title, length, rating, rental_rate
-- select title, length, rating, rental_rate from film;
-- select distinct rating from film;
-- order by rating;
-- select title, length from film
-- order by 2;
-- select title, rental_rate, length, rating from film
-- where rating = 'G';
-- select title, rental_rate, length, rating from film
-- where rental_rate = '2.99' and rating = 'G';
-- select title, rental_rate, length, rating from film
-- where rating = 'G' or rating = 'PG';
-- select title, rental_rate, length, rating from film
-- where rating in ('G', "PG", "PG-13");
select title, rental_rate, length, rating from film
where rating in ('G', "R",) and length >= 100;