10. Consider a database LOANS with the following table:
Table: LOANS
Start Date
Interest
AccNo Cust Name
Loan Amount Instalments int_Rate
19-07-2009
1200
1
12.00
R.K. Gupta
36
300000
22-03-2008
1800
2
500000
S.P. Sharma
10.00
48
08-03-2007
1600
3
K.P. Jain
300000
NULL
36
2250
06-12-2008
10.00
4
M.P. Yadav
800000
60
4500
03-01-2010
12.50
5
S.P. Sinha
36
200000
3500
05-06-2008
12.50
6
P. Sharma
700000
60
3800
05-03-2008
NULL
7
K.S. Dhall
500000
48
Answer the following questions.
(a) Display the sum of all Loan Amount whose Interest rate is greater than 10.
Answers
Answered by
2
Answer:
How to delete brainly account???
Explanation:
10. Consider a database LOANS with the following table:
Similar questions
Science,
4 months ago
Science,
4 months ago
Business Studies,
4 months ago
Science,
8 months ago
Science,
1 year ago