sqlite> select * from movies where name between 'D' AND 'F';
55|Despicable Me 2|comedy|2013|7.5
68|Despicable Me|comedy|2010|7.7
122|Dracula|horror|1992|7.5
128|Dark Shadows|horror|2012|6.2
139|End of Days|horror|1999|5.7
168|Elf|romance|2003|6.9
200|Dawn of the Planet of the Apes|drama|2014|7.7
203|Dances with Wolves|drama|1990|8.0

sqlite> select * from movies where year between 1900 AND 1980;
6|Star Wars|action|1977|8.7
32|Star Wars: Episode V - The Empire Strikes Back|action|1980|8.8
109|Jaws 2|horror|1978|5.7
116|The Amityville Horror|horror|1979|6.2
157|Gone with the Wind|romance|1939|8.2
161|Snow White and the Seven Dwarfs|romance|1937|7.7
174|The Sound of Music|romance|1965|8.0
194|Jaws|drama|1975|8.1
220|Seven|drama|1979|6.1