(Solved) : Assignment Develop Sql Query Select Books Currently Checked Past Due Returned Value Greate Q27657277 . . . .

ASSIGNMENT:

Develop a SQL query that will select all of the books that arecurrently checked out and are past due to be returned, which have avalue greater than $10.00. Your query must return the name,address, postal code, and phone number of the borrower, the nameand phone number of the librarian responsible for the transaction,the date the book was due to be returned, and the name, cost, andISBN number of the book. You query should sort the list by thereturn date in descending order.

WHAT I HAVE TRIED SO FAR:

SELECT br.First_name, br.Last_name, br.Address, br.Postal_code,br.Phone_number, l.First_name, l.Last_name, l.phone_number,bl.Return_date, b.Title, b.ISBN_number, b.Cost

FROM Booklended bl, BookCopy