SQL

Question

Consider the following Realtion

Borrower(borrower no , name , age)

Loan (copy no , borrower no , due date )

Retrieve the borrower name and number of books currently on loan for each of the borrower

1) Select borrower.name, count (*)

from loan where loan.borrower name= borrower.borrower name

group by borrower.borrower.no

2)

 Select borrower.name, count (*)

from loan , borrower where loan.borrower name= borrower.borrower name

group by borrower.borrower.no

3)

 Select borrower.name, count (*)

from loan, borrowe  where loan.borrower name= borrower.borrower name

group by loan .borrower.no

4) None of these

Answer 1

My answer was c

Because (I used” group By loan.Borrower no “because they will give me exactly only those borrowers who have taken loan . If I opt to take “Group By Borrower.Borrower No “then I will get tuples who have taken loan as well as who didn’t take any loan )

Am i right ?

Comments

join should be on the basis of Borrower.borrower no and Loan.Borrower no

only on this basis join of two relation will be there.?? in all the three option join is WRONG !! there may be printing mistake.??