ask expert You are working with a database that holds information about a library system. The database includes two tables: Books and Loans $.$ The Books table lists every book available in the library, and the Loans table records details about the books currently borrowed by patrons: Books $($ BookID, Title, Author, ISBN, PublicationYear $)$ Loans $($ LoanID, BookID, PatronID, LoanDate, DueDate, ReturnedDate $)$ Task: Write a SQL query to find all books that have been loaned out at least once this year but are not currently on loan $($i$.$e$.,$ no NULL values on the ReturnedDate column$).$ Your result should include the ISBN $,$ Title $,$ Author $,$ and the most recent LoanDate for these books. Your solution MUST use the semi$-$join operator.