Can we use Order by on a column that is not part of selected columns?

Question

Order by SQL

Answer 1

Yes you can.

For example you have a database "people" with columns: name, surname, age.
It is correct query:
SELECT name, surname FROM people ORDER BY age;

Answer 2

Okay