1. Write a query that displays the Book number, title, cost of all books. Sort results by book title (case insensitive).

2. Write a query that displays the checkout number, checkout date, due date and Patron last name for every book that is currently checked out ordered by due date. Join the tables using USING'

3. Write a query that displays the author ID, last name, first name and Book title for the books they have written. Sort by authors last name and then their first name. Join the tables using ON.

FIGURE P7.56 THE CHO7_FACT ERD CHECKOUT PK Check Num FK1 Book_Num FK2 Pat_ID Check_out_Date Check_Due Date Check_in_Date PATRON PK Pat ID ----H-1 Pat_FName Pat_L Name Pat_Type BOOK PK Book Num AUTHOR PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num + PK,FK2 Au ID