English Français Deutsch

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 1962
read "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

films.csv