Write a query to display patron ID, first name, last name, book title, checkout date for books that are still checked out. Order the results by checkout date in descending order and patron last name in ascending order. Tables AUTHOR D Columns Indexes Foreign Keys Triggers BOOK Columns Indexes Foreign Keys Triggers CHECKOUT Columns Indexes Foreign Keys Triggers PATRON Eolumns FII Indexes Foreign Keys Triggers WRITES Dill Views Administration Schemas Information Tables AUTHOR Columns AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR Indexes Foreign Keys Triggers BOOK Columns - BOOK_NUM B0nk trme " Triggers BOOK Columns - BOOK_NUM - BOOK_TITLE - BOOK_YEAR - BOOK_COST - BOOK_SUBJECT - PAT_ID Dindexes Foreign Keys Trinnam Columns CHECK.NUM BOOK_NUM PAT_ID CHECK_OUT_DATE CHECK_DUE_DATE CHECK_IN_DATE Indexces Foreign Keys Triggers PATRON [D Columns PAT_ID - PAT_FNAME - PAT_LNAME - PAT_TYPE Indexes PATRON WRITES Columns BOOK_NUM - AU_ID Indexes Foreign Keys Triggers Views Write a query to display patron ID, first name, last name, book title, checkout date for books that are still checked out. Order the results by checkout date in descending order and patron last name in ascending order. Tables AUTHOR D Columns Indexes Foreign Keys Triggers BOOK Columns Indexes Foreign Keys Triggers CHECKOUT Columns Indexes Foreign Keys Triggers PATRON Eolumns FII Indexes Foreign Keys Triggers WRITES Dill Views Administration Schemas Information Tables AUTHOR Columns AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR Indexes Foreign Keys Triggers BOOK Columns - BOOK_NUM B0nk trme " Triggers BOOK Columns - BOOK_NUM - BOOK_TITLE - BOOK_YEAR - BOOK_COST - BOOK_SUBJECT - PAT_ID Dindexes Foreign Keys Trinnam Columns CHECK.NUM BOOK_NUM PAT_ID CHECK_OUT_DATE CHECK_DUE_DATE CHECK_IN_DATE Indexces Foreign Keys Triggers PATRON [D Columns PAT_ID - PAT_FNAME - PAT_LNAME - PAT_TYPE Indexes PATRON WRITES Columns BOOK_NUM - AU_ID Indexes Foreign Keys Triggers Views