Imdb: Database

Since the official IMDb database is not open-source, the most useful content I can create for you is a based on the publicly available IMDb Datasets.

SELECT p.full_name, pr.characters, COUNT(*) as occurrences FROM principals pr JOIN people p ON pr.person_id = p.person_id WHERE pr.category = 'actor' AND pr.characters IS NOT NULL AND p.person_id = 'nm0000206' -- Replace with specific Actor ID GROUP BY p.full_name, pr.characters ORDER BY occurrences DESC LIMIT 1; imdb database

A crowdsourced repository of filming secrets and continuity errors. 2. The Power of the Rating System Since the official IMDb database is not open-source,

SELECT p.full_name, t.primary_title, t.avg_rating, COUNT(pr2.person_id) as total_roles FROM people p JOIN principals pr ON p.person_id = pr.person_id JOIN titles t ON pr.title_id = t.title_id LEFT JOIN principals pr2 ON p.person_id = pr2.person_id WHERE t.avg_rating > 8.0 GROUP BY p.full_name, t.primary_title, t.avg_rating HAVING COUNT(pr2.person_id) = 1 -- Only appeared in one project ORDER BY t.avg_rating DESC; The Power of the Rating System SELECT p