Question

Write the SQL Query for (i) to (vi) on the basis of table BANK given below:

BANK

Ac_No Cust_Name B_Name Amount Date_of_open No_of_transaction

A001 Agam Shah SBI 28000 2011-06-01 5

A002 Nishant Patel HDFC 22000 2015-07-02 7

A003 Krunal ICICI 66000 2015-06-04 9

A004 Twinkle HDFC 55000 2017-01-10 6

A005 Jinal ICICI 34000 2017-01-15 3

A006 Aaditya SBI 90800 2015-08-18 1

A007 Varsha AXIS 18000 2013-09-11 2

A008 Vishnu ICICI 97000 2015-08-13 5

A009 Dhruv Raj UCO 12000 2017-12-01 7

i. To display the name of customer in SBI who opened their account in

the year 2017.

ii. To display Ac_No,Amount, No_of_transaction of customers whose

bank is SBI or ICICI or UCO.

iii. To display the detail of customer whose name ends with ‘l’.

iv. To display the Date _ of_ Open of newest customer.

v. To count the total number of transactions in each bank separately.

vi. Remove the detail of all customers of UCO bank.​

Answer 1

sdtvt get VG hgyhvtynnhhhhhhhhhh hgyh Dy victory hvfubcgmch fu ch ch vhnvg by g ch hv hv bhv v