Question

Comedy Movies
Description
Write a query to list all the films existing in the 'Comedy' category and arrange them in the alphabetical order.



Sample Output

title

ACADEMY DINOSAUR

Answer 1

Answer:

answer I don't know but I will tell answer after but mark me brilliant please

Answer 2

Answer:

We can use this query:

Explanation:

select Title

from flim

inner join flim_category

using (flim_id)

inner join category

using (categor_id)

where name = 'comedy'

order by title;

So here we are inner join to couple up film_category table and category table using film_id and category_id.

We filtered out the comedy category from the category table using' where.

And last we ordered it by title which will display the films with comedy category in alphabetical order.