Write SQL Query:

Branch_ID	Bank_Name	Loan	Loan status	Account_no	Client name	address
201	MBL	80000	Accepted	101	William	New York
202	UBL	90000	pending	102	Michael	Phoenix
203	JS	77000	open	103	Anthony	Chicago
204	Metro	68000	Accepted	104	Aiden	Houston
205	Al Habib	75000	close	105	Matthew	Fresno

1. Write sql query to create a stored procedure name “SelectAllBank” that select client name, address and bank.
2. Write sql query to create a stored procedure that display details of those clients whose loan status is ‘accepted’.
3. Write sql query to create a stored procedure list all clients who either have applied for loan or not.  
4. Write sql query to create a stored procedure list all clients who have applied for loan.
5. Write sql query to create a stored procedure list all those clients who have not applied for loan.