$5$Assume that you are the Manager of the Loans department of a Finance House. To keep track of the loans you have created two tables : CUSTOMERS and loans. The sample data in these tables is given below : Table: CUSTOMERS

C ID	C Name	Phone
$\displaystyle 00001$	Raj Malhotra	$\displaystyle 1234567890$
$\displaystyle 00003$	David Xavier	$\displaystyle 3456789012$
$\displaystyle 00004$	Damini Iyer	$\displaystyle 3156789012$
$\displaystyle 00008$	Abdul	$\displaystyle 2345678901$

Table: LOANS

SNo	C ID	L Amt	L Date	Terms	RoI
$\displaystyle 1$	$\displaystyle 00003$	$\displaystyle 200000$	$\displaystyle 2025$-$\displaystyle 12$-$\displaystyle 06$	$\displaystyle 60$	$\displaystyle 7.80$
$\displaystyle 2$	$\displaystyle 00008$	$\displaystyle 2500000$	$\displaystyle 2023$-$\displaystyle 08$-$\displaystyle 09$	$\displaystyle 60$	$\displaystyle 9.00$
$\displaystyle 3$	$\displaystyle 00001$	$\displaystyle 500000$	$\displaystyle 2025$-$\displaystyle 08$-$\displaystyle 13$	$\displaystyle 48$	$\displaystyle 6.00$
$\displaystyle 4$	$\displaystyle 00003$	$\displaystyle 300000$	$\displaystyle 2026$-$\displaystyle 12$-$\displaystyle 07$	$\displaystyle 36$	$\displaystyle 8.00$
$\displaystyle 5$	$\displaystyle 00004$	$\displaystyle 600000$	$\displaystyle 2026$-$\displaystyle 12$-$\displaystyle 07$	$\displaystyle 60$	$\displaystyle 6.00$

Note : The tables may contain more records than shown here. The management of the Finance House needs certain reports from you. Write the queries to extract the following data to create the reports :

(i)Number of records from LOANS table where Rate of Interest (ROI) is above 7.0.(ii)Names of the customers whose loan amount (L_Amt) is above 1000000.(iii)C_ID, C_Name and Terms of all those records where Loan Date (L_Date) is after $\displaystyle 31^{\text {st }}$ December, 2024.(iv)(a) Details of all the loans in the descending order of RoI.

OR

(b) C_ID and average term for each C_ID from the LOANS table.

Computer Science · Structured Query Language