State a query to display the book number, title, author last name

 State a query to display the book number, title, author last name, author first name, patron ID, last name, and patron type for all books currently checked out to a patron. Sort the results by book title 

 

Transcribed Image Text:

CHECKOUT PK Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK -H- BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID HH -----H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num +4PK,FK2 Au ID AUTHOR PK Au ID Au_FName Au_LName Au_Birth Year HH CHECKOUT PK Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK -H- BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID HH -----H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num +4PK,FK2 Au ID AUTHOR PK Au ID Au_FName Au_LName Au_Birth Year HH

Answer rating: 100% (QA)

SELECT BOOKBookNum BOOKBook Titl... View the full answer