Relation Tutorial 9
Order films by director and title
read "films.csv"
order director, film
project director, film, year
print
| director | film | year |
|---|---|---|
| Godard | A bout de souffle | 1960 |
| Godard | Pierrot le fou | 1965 |
| Godard | Week-End | 1967 |
| Kluge | Der starke Ferdinand | 1976 |
| Truffaut | Jules et Jim | 1962 |
| Truffaut | Tirez sur le pianiste | 1960 |
| Varda | Cléo de 5 à 7 | 1962 |
| Varda | Sans toi ni loi | 1985 |
| von Trotta | Die verlorene Ehre der Katharina Blum | 1975 |
Order films by year and only the 3 newest
read "films.csv"
order year 9
limit 1 3
project year, film, director
print
| year | film | director |
|---|---|---|
| 1985 | Sans toi ni loi | Varda |
| 1976 | Der starke Ferdinand | Kluge |
| 1975 | Die verlorene Ehre der Katharina Blum | von Trotta |
Show average of films by director with 2 decimal values
read "films.csv"
project director, film count
project film_count avg
format film_count_avg "%0.2f"
print
| film_count_avg |
|---|
| 1.80 |