English Français Deutsch

Relation Tutorial 6

Show the number of titles by director

read "films.csv"
project director, film count
print

director film_count
Godard 3
Truffaut 2
Varda 2
von Trotta 1
Kluge 1

Show the average number of titles by director

read "films.csv"
project director, film coun
project film_count avg
print

film_count_avg
1.8