Write a query to display the author ID, author last name, book title, checkout date, and patron last name for all the books written by authors with the last name “Bruer” that have ever been checked out by patrons with the last name “Miles.” Sort the results by check out date (Figure P7.100). 

Transcribed Image Text:

Figure P7.100 Books by Author for Patron "Miles" AU_ID AU_LNAME 251 Bruer 251 Bruer BOOK TITLE CHECK OUT_DATE PAT_LNAME Capture the Cloud 4/21/2021 Miles Capture the Cloud 5/15/2021 Miles