DigiValet Interview Question

How to select certain columns and order them in SQL?