Using the BANK database write and execute the following SQL queries: 1. Write a query in...

Transcribed Image Text:

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, Iname) 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, Iname) 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.

Answer rating: 100% (QA)

To execute the following SQL queries youll need access to the BANK database and a SQL client Here ar... View the full answer