Questions from Database Systems

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

Write a query to display the author last name, first name, book title, and year for each book. (Figure P8.50) Figure P8.50 Author name and book title

Q: Write a query to display the patron ID, book number,

Write a query to display the patron ID, book number, patron first name and last name, and book title for all currently checked out books. (Remember to use the redundant relationship described in the...

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

Write a query to display the patron ID, full name (first and last), and patron type for all patrons. Sort the results by patron type, then by last name and first name. Ensure that all sorting is cas...

Q: Write a query to display the book number and the number of

Write a query to display the book number and the number of times each book has been checked out. Do not include books that have never been checked out. (Figure P8.53) Figure P8.53 Times checked out...

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

Write a query to display the author ID, first and last name, book number, and book title of all books in the subject “Cloud”. Sort the results by book title and th...

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

Write 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 t...

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

Write a query to display the book number, title, and number of times each book has been checked out. Include books that have never been checked out. Sort the results in descending order by the number...

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

Write a query to display the book number, title, and number of times each book has been checked out. Limit the results to books that have been checked out more than 5 times. Sort the results in desc...

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

Write a query to display the author ID, author last name, book title, checkout date, and patron last name for all the books written by authors with the last name “Bruerâ€&...

Q: Write the SQL code to find the average bonus percentage in the

Write the SQL code to find the average bonus percentage in the EMP_2 table you created in Problem 8. Details from Problem 8: CREATE TABLE EMP_2 ( EMP_NUM CHAR(3) NOT NULL UNIQUE, EMP_LNAME VARCHA...