list all films categories

SELECT c.name FROM category c INNER JOIN film_category fc ON c.category_id = fc.category_id;