Where am I wrong here:

Even though writing the query as

SELECT * FROM movies ORDER BY year, title;

sorts the result set in ascending order by default (for MySQL), it's better to be explicit by adding an ordering keyword (e.g. ASC or DESC) for each column to guarantee the desired order as some SQL's may not sort the result set in ascending order by default.

So, in light of the question being asked, I wrote mine like so, and it passed.

SELECT * FROM movies ORDER BY year ASC, title ASC;

I think you don't need to write 'ASC' at all since it's a default value.

SELECT * FROM movies ORDER BY year, title;

Database Foundations

Challenge Task 1 of 2

Order "actors" by "name" in reversed alphabetical order.

SELECT * FROM actors ORDER BY name DESC;

Challenge Task 2 of 2

Order "movies" with the release "year" ascending with the "title" in alphabetical order. Type in your command below, then press Enter.

SELECT * FROM movies ORDER BY year ASC, title ASC;

I had trouble with this too! Had to enter it about 4 times in order for it to work.

I had the same problem on Challenge Task 2 of 2, none of these combinations worked:

SELECT * FROM movies ORDER BY year, title; SELECT * FROM movies ORDER BY year ASC, title; SELECT * FROM movies ORDER BY year, title DESC; SELECT * FROM movies ORDER BY year ASC, title DESC;

These answers are wrong, but they also did not work, I tested them just to be thorough: SELECT * FROM movies ORDER BY title, year; SELECT * FROM movies ORDER BY title, year ASC; SELECT * FROM movies ORDER BY title DESC, year; SELECT * FROM movies ORDER BY title DESC, year ASC;

*** Update: I believe it has been fixed.

I have entered what I thought was correct in multiple times but it keeps returning bummer for the last couple of videos. The commands I am entering work just fine in the MySQL workbench.