Question: Using the BANK database write and execute the following SQL queries: 1. Write a query in SQL to display the customer_name(fname, Iname) whose acc_status is


Using the BANK database write and execute the following SQL queries: 1. Write a query in SQL to display the customer_name(fname, Iname) whose acc_status is "Active". 2. Write a query in SQL to display the customer_name (fname, lname) who takes the loan from the Irbid branch. 3. Write a query in SQL to display the total loan amount for each branch. 4. Write a query in SQL to display the Maximum, Minimum, and total balance for each account type. 5. Write a query in SQL to display the cust_id, fname, and city for each customer when your balance is less than total amount of loans. Using the BANK database write and execute the following SQL queries: 1. Write a query in SQL to display the customer_name(fname, Iname) whose acc_status is "Active". 2. Write a query in SQL to display the customer_name (fname, lname) who takes the loan from the Irbid branch. 3. Write a query in SQL to display the total loan amount for each branch. 4. Write a query in SQL to display the Maximum, Minimum, and total balance for each account type. 5. Write a query in SQL to display the cust_id, fname, and city for each customer when your balance is less than total amount of loans
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
