Question

11 This problem is about writing SQL for the relation Repayment from the above proablem. problement(borrower id, name, address, loanamoun id, name, address, loanamount, requestdatoe, nt, requestdate, repayment date, request amount) a) (4 Rrl points) Write an SQL request that returns all the tuples with information on repayments from the aith id equal to 42, and where the lent amount exceeds 1000 USD. borrower b) (4 points)Write an SQL request that for each address finds the total repaid amount for the address.

Answer 1

1. It will be in waiting state because process moves into the waiting state if it needs to wait for a resource, such as waiting for user input, waiting for a file to become available, or waiting for an I/O.
2. It will be in terminated state because once the process finishes its execution, or it is terminated by the operating system, it is moved to the terminated state where it waits to be removed from main memory.
3. It will be in ready state because the process is waiting to be assigned to a processor. Ready processes are waiting to have the processor allocated to them by the operating system so that they can run.
4. It will be in running state because once the process has been assigned to a processor by the OS scheduler, the process state is set to running and the processor executes its instructions.

1. SELECT     borrower_id, name, address, loanamount, requestdate, repayment_date, request_amount FROM         Repayment WHERE     (borrower_id = 42) AND (loanamount > 100)
2. select address,SUM(request_amount) as Total_amount from Repayment group by address

3.select name,address from repayment where address in (select address from repayment group by address having

COUNT(address)<2)

4. delete from repayment where borrower_id in (select borrower_id from Repayment group by address,borrower_id having SUM(request_amount)>=AVG(loanamount))

Here i am including 2 screenshots also. first screen shot of the repayment table which have dummy data and second screenshot of repayment table after running 4th query.