Problem 56

Write a query that displays the book title, cost and year of publication for every book in the system. Sort the results by book title.

Problem 57

Write a query that displays the first and last name of every patron, sorted by last name and then first name. Ensure the sort is case insensitive (Figure P7.57). (50 rows)

Problem 58

Write a query to display the checkout number, checkout date, and due date for every book that has been checked out sorted by checkout number (Figure P7.58). (68 rows)

Problem 59

Write a query to display the book number, book title, and subject for every book sorted by book number (Figure P7.59). (20 rows)

Problem 60

Write a query to display the different years in which books have been published. Include each year only once and sort the results by year (Figure P7.60).

Problem 61

Write a query to display the different subjects on which FACT has books. Include each subject only once and sort the results by subject (Figure P7.61).

Problem 62

Write a query to display the book number, title, and cost of each book sorted by book number (Partial results are shown in Figure P7.62).

Problem 63

Write a query to display the checkout number, book number, patron ID, checkout date, and due date for every checkout that has ever occurred in the system. Sort the results by checkout date in descending order and then by checkout number in ascending order (Partial results are shown in Figure P7.63).

Problem 64

Write a query to display the book title, year, and subject for every book. Sort the results by book subject in ascending order, year in descending order, and then title in ascending order (Partial results are shown in Figure P7.64).