Which actor has directed the most movies?
Use the Neo4j Browser window to the right of the screen to run GDS calls and enter the answer in the box below.
✓
Woody Allen
CALL gds.graph.drop( 'actorDirectedMovie', false);
CALL gds.graph.project(
'actorDirectedMovie',
['Actor', 'Movie'],
'DIRECTED'
);
CALL gds.degree.stream( 'actorDirectedMovie')
YIELD nodeId, score
RETURN gds.util.asNode(nodeId).name AS name, score AS directedCount
ORDER BY directedCount DESC, name DESC LIMIT 5;
╒═══════════════════╤═══════════════╕
│"name" │"directedCount"│
╞═══════════════════╪═══════════════╡
│"Woody Allen" │42.0 │
├───────────────────┼───────────────┤
│"Steven Spielberg" │30.0 │
├───────────────────┼───────────────┤
│"Martin Scorsese" │30.0 │
├───────────────────┼───────────────┤
│"Clint Eastwood" │30.0 │
├───────────────────┼───────────────┤
│"Steven Soderbergh"│25.0 │
└───────────────────┴───────────────┘