Databases · Junior · Question 11 of 75

Which query returns the names of users older than 30, sorted by name?

✓Correct answer: SELECT name FROM users WHERE age > 30 ORDER BY name;
2SELECT name WHERE age > 30 FROM users SORT name;
3SELECT name FROM users ORDER BY name WHERE age > 30;

Explanation

Clauses have a fixed order: SELECT ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY ... LIMIT.

Further reading

PostgreSQL: SELECT ↗

Test yourself

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