What is the name and salary of all employees in order of salary?
SELECT name ,  salary FROM Employee ORDER BY salary
name and salary of all employees refers to SELECT name, salary FROM Employee; in order of salary refers to ORDER BY salary;