SELECT with SUM, GROUP BY and ORDER BY

Q:16
Display the total deposit of each branches in the order of branch.


SQL>  SELECT BRANCH,SUM(AMOUNT) FROM DEPOSIT GROUP BY BRANCH ORDER BY BRANCH;

BRANCH               SUM(AMOUNT)
-------------------- -----------
CALICUT                   160000
COCHIN                     30000
TRICHUR                    80000