genre_count (view)

45 rows

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE VIEW genre_count AS
SELECT 
g.label as genre
,COUNT(1) AS movies
FROM root_genres g
JOIN starting_list m
ON m.genre LIKE "%"||g.label||"%"
GROUP BY
g.label
ORDER BY
COUNT(1) DESC;