-- 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';