Relation Tutorial 4
Select all films by Godard
read "films.csv"
select director == "Godard"
print
| film | director | year |
|---|---|---|
| A bout de souffle | Godard | 1960 |
| Pierrot le fou | Godard | 1965 |
| Week-End | Godard | 1967 |
Select all from 1962read "films.csv"
select year = 1962
print
| film | director | year |
|---|---|---|
| Cléo de 5 à 7 | Varda | 1962 |
| Jules et Jim | Truffaut | 1962 |
Select the films of the sixties with a title shorter than 10 charactes
read "films.csv"
select year >= 1960 and year <= 1969 and length(film) < 10
print
| film | director | year |
|---|---|---|
| Week-End | Godard | 1967 |