
SELECT * FROM client ORDER BY last_name;

SELECT id, grade FROM student_grade
   WHERE course_id="CS-101" AND semester="Fall"
         AND year="2012" ORDER BY grade;

SELECT customer_name, amt FROM sale ORDER BY amt DESC;

