SELECT * FROM cars
WHERE year BETWEEN 1970 AND 1980;
brand | model | year --------+--------+------ BMW | M1 | 1978 Toyota | Celica | 1975 (2 rows)