Questions from Database Systems

Q: Write a query to display the patron ID, first and last

Write a query to display the patron ID, first and last name of all patrons that have never checked out any book. Sort the result by patron last name then first name. (Figure P8.59) Figure P8.59 Patro...

Q: Write the query that will generate only the records that are unique

Write the query that will generate only the records that are unique to the CUSTOMER_2 table. (Figure P8.6) Figure P8.6 Customers unique to the CUSTOMER_2 table

Q: Write a query to display the patron ID, last name,

Write a query to display the patron ID, last name, number of times that patron has ever checked out a book, and the number of different books the patron has ever checked out. For example, if a given...

Q: Write a query to display the average number of days a book

Write a query to display the average number of days a book is kept during a checkout. (Figure P8.61) Figure P8.61 Average days kept

Q: Write a query to display the patron ID and the average number

Write a query to display the patron ID and the average number of days that patron keeps books during a checkout. Limit the results to only patrons that have at least 3 checkouts. Sort the results in...

Q: Write a query to display the book number, title, and

Write a query to display the book number, title, and cost of books that have the lowest cost of any books in the system. Sort the results by book number. (Figure P8.63) Figure P8.63 Least expensive b...

Q: Write a query to display the author ID, first and last

Write a query to display the author ID, first and last name for all authors that have never written a book with the subject Programming. Sort the results by author last name. (Figure P8.64) Figure P8...

Q: Write a query to display the book number, title, subject

Write a query to display the book number, title, subject, average cost of books within that subject, and the difference between each book’s cost and the average cost of books in that...

Q: Write a query to display the book number, title, subject

Write a query to display the book number, title, subject, author last name, and the number of books written by that author. Limit the results to books in the Cloud subject. Sort the results by book...

Q: Write a query to display the lowest average cost of books within

Write a query to display the lowest average cost of books within a subject and the highest average cost of books within a subject. (Figure P8.67) Figure P8.67 Lowest and highest average subject costs...