Forum Discussion
Solved
Finding top 5s of multiple actors
Hello there everyone, so I've joined some date sets/tables and am almost done with my assignment, I "only" need to determine the top 5 categories of the 5 actors who play the most roles. The latt...
If to imitate on such model
first you group by actor_id without aggregation
next sort each Data table by Qty (simplest by adding another column)
and keep Top5 in resulting table
Remove intermediate columns and expand latest one
.png){kind=link}
Mmrtlm Difficult to judge on the basis of a screenshot alone. Can you upload your file?