I'm a bit stuck on number two, it asks :
"Return all of the unique years in the movies table sorted from oldest to newest."
But when I add the "ADD year ASC; it does not return anything, when I take it off then it returns all the movies from that year and genre. I don't think I am writing it out correctly, any ideas?
SELECT DISTINCT year, genre, name FROM movies
WHERE genre = 'drama'
AND year ASC;