Log in Sign up for FREE

sql group by

Last updated about 5 years ago

8 questions

1

Write your name

1

Write your class

1

Write your section

1

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

1

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

1

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

1

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

1

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