group by is used when we use aggregate functions on the columns in a query the other columns

should be in group by query

example:

select empno,ename,sum(sal) from emp

group by empno,ename

Order by is used to sort values either in ascending or descending order