SELECT Query

Q:9
Display the names and AccNo. of depositors in CALICUT branch who have deposited more than Rs. 20,000/-.


SQL>  SELECT ACCNO, NAME,AMOUNT FROM DEPOSIT WHERE BRANCH='CALICUT' AND AMOUNT > 20000;

     ACCNO NAME                          AMOUNT
---------- ------------------------- ----------
      1001 SYAM KUMAR                     55000
      1006 DEVA KUMAR                     60000
      1007 ASHOK KUMAR                    45000