You can use GROUP BY and ORDER BY in the same query.

Interview Questions

http://www.geocities.com/srcsinc/Questions.html

GROUP  BY and ORDER BY can be used in the same query and it is NOT required that they be the same column.  GROUP BY controls the way the data is organized for sumarization.  ORDER BY simply sorts the rows of the result.  The following is legal:

SELECT  DEPARTMENT, AVG(SALARY) AS AVG

FROM     EMPLOYEE

GROUP BY DEPARTMENT

ORDER BY AVG

Group by controls the presentation of the rows, 

Order by controls the presentation of the columns  for the results of the SELECT statement

group :- is used to find the sum

and orderby is like checking the condition .

furter explansion will be provided upon req!