Midterm: SQL 1
- For each book that has been both borrowed and requested, give the phone number of the borrower and the requester
Select b.phone_number, r.phone_number
From Library_Patron as b, Library_Patron as r, Book_Request as br, Borrowed as bo
Where b.card_number = borrowers_card_number and
r.card_number = requesters_card_number and
bo.book_ISBN = br.book_ISBN