-- Películas que duren entre 100 y 120 minutos o entre 50 y 70 minutos
select * from film where length >= 100 and length<=120
OR length between 50 and 70
order by length;
-- Buscar todos los clientes (customer) de paises que empiecen por ‘A’ (27)
select customer.* from country join city on country.country_id=city.country_id
join address on city.city_id=address.city_id
join customer on address.address_id=customer.address_id
where country like 'a%';
-- Buscar todos los actores que hayan trabajado en películas de una longitud (length) mayor de 140 (200)
select distinct actor.* from actor join film_actor on actor.actor_id=film_actor.actor_id
join film on film_actor.film_id=film.film_id
where length>140;
-- Categorías con películas de rating ‘R’ (solo el nombre) (16)
select distinct name from category join film_category on category.category_id=film_category.category_id
join film on film_category.film_id=film.film_id
where rating='R';
-- Películas para niños (children) o familiares (Family) (129)
select distinct title from category join film_category on category.category_id=film_category.category_id
join film on film_category.film_id=film.film_id
where name='children' or name='family';
