Sign up for FREE

sql group by

Last updated over 5 years ago

8 questions

1

1

1

1

1

1

1

1

Question 1

1.

Write your name

Question 2

2.

Write your class

Question 3

3.

Write your section

Question 4

4.

Q1. To find the highest loan amount whose interest rate is 12.5

Question 5

5.

Q2. To find customer name and minimum loan amount for SBI Bank?(using above table)

Question 6

6.

Q3. To find bank name who has highest interest rate.(using above table)

Question 7

7.

Q4. To count total number of customers whose interest rate is NULL(using above table)

Question 8

8.

Q5. To find total loan amount financed in year 2010. hint: for year 2010 check in range of 1 jan 2010 to 31st jan 2020