DigiValet interview question

How to select certain columns and order them in SQL?