6.ORDER BY

 SELECT name

FROM student

ORDER by NAME;

SELECT name

FROM student

ORDER by NAME DESC;