Twa kɔ nsɛm atitiriw so

Sign up for FREE

sql group by

Last updated over 5 years ago

8 Nsɛmmisa

1

1

1

1

1

1

1

1

Asemmisa {{asɛmmisaAhyɛnsode}}

1.

Write your name

Asemmisa {{asɛmmisaAhyɛnsode}}

2.

Write your class

Asemmisa {{asɛmmisaAhyɛnsode}}

3.

Write your section

Asemmisa {{asɛmmisaAhyɛnsode}}

4.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

5.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

6.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

7.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

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