select f.title, l.name from film f
join language l using (language_id)
where l.name = 'Spanish';
select f.title, c.name from film f
join film_category l using (film_id)
join category c using (category_id)
where c.name = 'Horror';
select customer.*
from rental
join customer using (customer_id)
where rental_date between '2005-01-01' and '2005-01-31';
select * from actor;
select * from category;