FAQ: Queries - Order By

This community-built FAQ covers the “Order By” exercise from the lesson “Queries”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

Learn SQL

FAQs on the exercise Order By

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

In what case do we need to specify ASC explicitly? If it’s the default, we never need it, do we?

You wouldn’t need to, I don’t believe, in a standard SQL query, but I suppose one might use it if the query were written in function in a language like Python or JavaScript where the ORDER BY direction [ASC or DESC] might be dependent on some condition.

Hi.

How does one use ORDER BY, while also filtering out NULL results?

SELECT *
FROM movies
WHERE year > 1990 AND imdb_rating IS NOT NULL
ORDER BY name ASC, imdb_rating ASC;

But I’m not returning any results now that IS NOT NULL condition is there. Curious how that would work?

Thanks!

thats odd, i wrote the code and got the results.
image