Consider the following table BANK. Write commands of SQL for (i) to (v):

Table: BANK

Acct_No	Acct_Holder	Acct_type	Opening_Bal	Contact_no
11001	Atul	Saving	5000	9216245833
11002	Mansha	Current	10000	9466615675
11003	Rahul	Current	2000	9416822012
11004	Mehak	Saving	NULL	7805634056
11005	Akshay	Fixed Deposit	50000	8732216155

(i) Show the details of AccountHolders who have opened a Current Account.

(ii) Display the Account Holder and Contact No. of those who have not deposited any opening balance.

(iii) Display the unique Account type available in the table Bank.

(iv) Display all the details of those Accounts whose Account Holder name’s 2nd character is "a".

(v) Add a new record with the following data.

11006, "Tamanna", "Fixed", 70000, 9255617800

(i)

SELECT * 
FROM BANK
WHERE ACCT_TYPE = 'CURRENT';

Output

+---------+-------------+-----------+-------------+------------+
| Acct_No | Acct_Holder | Acct_type | Opening_Bal | Contact_no |
+---------+-------------+-----------+-------------+------------+
|   11002 | Mansha      | Current   |    10000.00 | 9466615675 |
|   11003 | Rahul       | Current   |     2000.00 | 9416822012 |
+---------+-------------+-----------+-------------+------------+

(ii)

SELECT ACCT_HOLDER, CONTACT_NO 
FROM BANK
WHERE OPENING_BAL IS NULL;

Output

+-------------+------------+
| ACCT_HOLDER | CONTACT_NO |
+-------------+------------+
| Mehak       | 7805634056 |
+-------------+------------+

(iii)

SELECT DISTINCT Acct_type 
FROM BANK;

Output

+---------------+
| Acct_type     |
+---------------+
| Saving        |
| Current       |
| Fixed Deposit |
+---------------+

(iv)

SELECT * 
FROM BANK
WHERE Acct_Holder LIKE '_a%';

Output

+---------+-------------+-----------+-------------+------------+
| Acct_No | Acct_Holder | Acct_type | Opening_Bal | Contact_no |
+---------+-------------+-----------+-------------+------------+
|   11002 | Mansha      | Current   |    10000.00 | 9466615675 |
|   11003 | Rahul       | Current   |     2000.00 | 9416822012 |
+---------+-------------+-----------+-------------+------------+

(v)

INSERT INTO BANK
VALUES (11006, 'Tamanna', 'Fixed', 70000, 9255617800);