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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!