What are the unique names of all race held between 2014 and 2017?
SELECT DISTINCT name FROM races WHERE YEAR BETWEEN 2014 AND 2017
unique names = DISTINCT(name); held between 2014 and 2017 refers to YEAR BETWEEN 2014 AND 2017;