Write SQL Query: Branch_ID Bank_Name Loan Loan status Account_no Client name address 201 MBL 80000 Accepted 101
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
- Write sql query to create a stored procedure name “SelectAllBank” that select client name, address and bank.
- Write sql query to create a stored procedure that display details of those clients whose loan status is ‘accepted’.
- Write sql query to create a stored procedure list all clients who either have applied for loan or not.
- Write sql query to create a stored procedure list all clients who have applied for loan.
- Write sql query to create a stored procedure list all those clients who have not applied for loan.
Related Book For
Entrepreneurial Finance
ISBN: 978-0538478151
4th edition
Authors: J . chris leach, Ronald w. melicher
Posted Date: