Write a query to display the patron ID, book number, and days kept for each chec

Question

Write a query to display the patron ID, book number, and days kept for each check-out. "Days kept" is the difference from the date on which the book is returned to the date it was checked out. -Need an answer in correct MySQL syntax. Question is from Database Systems 12e, CHP_08, question 45P. Thanks

Explanation / Answer

# Query => # in CHECKOUT table Column 'PAT_ID' represent Patron ID, # Column 'BOOK_NUM' represent Book Number select PAT_ID as "PATRON ID", BOOK_NUM as "Book Number", DATEDIFF(check_in_date, check_out_date) as "Days kept" from CHECKOUT;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.