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

Using the BANK database write and execute the following SQL queries: 1.

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.

Step by Step Solution

3.40 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

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!