SELECT with COUNT()

Q:13
Display the number of depositors in each branch who have more than Rs. 50,000/- as deposit.


SQL>  SELECT BRANCH, COUNT(*) FROM DEPOSIT WHERE AMOUNT > 50000 GROUP BY BRANCH;

BRANCH                 COUNT(*)
-------------------- ----------
CALICUT                       2