select
film.film_id,
film.title,
category.name as category
from
film
join
film_category on film.film_id = film_category.film_id
join
category on film_category.category_id = category.category_id
where
category.name = 'Comedy'
union
select
film.film_id,
film.title,
category.name as category
from
film
join
film_category on film.film_id = film_category.film_id
join
category on film_category.category_id = category.category_id
where
category.name = 'Music'
union
select
film.film_id,
film.title,
category.name as category
from
film
join
film_category on film.film_id = film_category.film_id
join
category on film_category.category_id = category.category_id
where
category.name = 'Travel'
order by
film.film_id;
;
show status like 'Last_query_cost';