Database [repack] - Imdb

Data-driven rankings that track the "trending" status of industry professionals.

Direct links to agents, managers, and production companies. imdb database

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; Data-driven rankings that track the "trending" status of