Give all information regarding instructors, in order of salary from least to greatest.
SELECT * FROM instructor ORDER BY salary
all information = SELECT *; order of salary from least to greatest = ORDER BY salary ASC (though ASC is default and can be omitted);