Databases · Junior · Question 12 of 75

In what logical order does the database evaluate the parts of a query?

1SELECT → FROM → WHERE → ORDER BY
✓Correct answer: FROM/JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT
3In the order they are written

Explanation

That's why a column alias defined in SELECT can't be used in WHERE, but can be used in ORDER BY.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.