/* Sorting with the ORDER BY clause */

SELECT  course_id, description, price
FROM  course
ORDER BY price;



/* Sorting on multiple columns */

SELECT  course_id, description, price
FROM  course
ORDER BY price, description ;



/* Specifying Ascending or Desending */

SELECT  course_id, description, price
FROM  course
ORDER BY price ASC, description DESC;



/* Using the column position rather than name */

SELECT  description, price, course_id
FROM  course
ORDER BY 2, 1 ;


SELECT  * 
FROM  student, class
WHERE ssn = stu_ssn
ORDER BY 2, 7 DESC;