Problem 87Write a query to display the patron ID, book number, and days kept for eachcheckout. "Days Kept" is the difference from the date on which the book isreturned to the date it was checked out. Sort the results by days kept indescending order, then by patron ID, and then by book number (Figure P7.87). (68rows)PATRONBOOKDays Kept1160524078116552357811855240781219524878122252407812265244781202523677121852367712285237771220523576Figure 7.87Task Database SchemaThe schema for the Ch07_FACT database is shown below and should be used to answer thenext several problems. Click this image to view it in its own tab.FIGURE P7.56 THE CH07_FACT ERDCHECKOUTPATRONPKCheck NumPK Pat IDFK1 Book_NumFK2 Pat_IDCheck_Out_DateCheck_Due_DateCheck_In_Date>0-----H-Pat_FNamePat LNamePat_TypeBOOKAUTHORPKBook_NumPK Au IDBook_TitleBook_YearBook_CostBook_SubjectFK1 Pat_IDAu_FNameAu_LNameAu_BirthYearWRITESPK,FK1 Book NumPK,FK2 Au IDThe CIS Department at Tiny College maintains the Free Access to Current Technology (FACT)library of e-books. FACT is a collection of current technology e-books for use by faculty andstudents. Agreements with the publishers allow patrons to electronically check out a book,

In SQL, to calculates the number of days between two dates, DATEDIFF() function is used. It retrieve…

Write a query to display the patron ID, book number, and days kept for each checkout. "Days Kept" is the difference from the date on which the book is returned to the date it was checked out. Sort the results by days kept in descending order, then by patron ID, and then by book number (Figure P7.87).

Write a query to display the patron ID, book number, and days kept for each checkout. "Days Kept" is the difference from the date on which the book is returned to the date it was checked out. Sort the results by days kept in descending order, then by patron ID, and then by book number (Figure P7.87).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

Q: Write a query to display the first name, last name, phone number, title, and department number of…

A: Actually, A database is a collection of information that is organized so that it can be easily…

Q: Write a query to display the subject and the number of books in each subject. Sort the results by…

A: Hey! Hope you are doing good! Thanks for the question. Since you have not specified the version of…

Q: write a query that displays employee last names, department numbers, and all the employees who work…

A: Here, SELECT statement is used along with the ON, WHERE, and ORDER BY clause.

Q: Write a query to display the Director Name and their age. The result-set should only show directors…

A: CREATE TABLE director ( dir_age INT NOT NULL, dir_name VARCHAR(30) NOT NULL, ); INSERT INTO…

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: SQL query The Round() function is used to round off the number to the desired decimal places. The…

Q: Write a query to display the first name, last name, and email address of employees hired from May 1,…

A: Here we have to write 2 queries whose details are as follows:Write a query to display the first…

Q: Write a query to display the book number, title and cost of books that have the lowest cost of any…

A: Query: In general, the term query describes a question or request that is made by a user or another…

Q: Write a query to display the average number of days a book is kept during a checkout (Figure…

A: Solution: Given, Schema structure is-

Q: inventory, i.e. the sum of all products on hand for each brand id. Sort the output by brand id in…

A: Here have to determine sql query for given problem.

Q: Write a query to display the first name, last name, street, city, state, and zip code of any…

A: Structured Query Language (SQL) can be defined in such a way that it is a standardized programming…

Q: Display the employee's record who were hired on a specific date. The hiredate is entered by user run…

A: SQL is a structured query language, that's used to extract and manipulate the data from the table.…

Q: Write a query to display the employee number, last name, email address, title, and department name…

A: QUERY: SELECT EMP_NUM, EMP_LNAME,EMP_EMAIL, EMP_TITLE,DEPT_NAME FROM EMPLOYEE WHERE EMP_TITLE NOT…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE: - Define columns: - MOVIE_NUM as INT (Primary Key) -…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Create a query to show the subject and the quantity of books in each category. Sort the results in…

A: Introduction: Important information to remember: Hey! I hope you're doing well! Thank you for your…

Q: Write a query to list the author last name, author first name and the book title and cost for each…

A: Solution: FROM: It is used to get data from the table WHERE: It is used to list the data where given…

Q: Create a query for each of the following, save and print a copy: Books on a loan, using only…

A: It is based on the Relational Database Management System(RDBMS) having executed through…

Q: Write a query that returns the EMP_NUM and Number of ratings he/she earned (based on EARNEDRATING…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Write a query to display the employee number, last name, first name, salary “from” date, salary end…

A: Solution: Given, Write a query to display the employee number, last name, first name, salary…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

Problem 87
Write a query to display the patron ID, book number, and days kept for each
checkout. "Days Kept" is the difference from the date on which the book is
returned to the date it was checked out. Sort the results by days kept in
descending order, then by patron ID, and then by book number (Figure P7.87). (68
rows)
PATRON
BOOK
Days Kept
1160
5240
78
1165
5235
78
1185
5240
78
1219
5248
78
1222
5240
78
1226
5244
78
1202
5236
77
1218
5236
77
1228
5237
77
1220
5235
76
Figure 7.87
Task

Database Schema
The schema for the Ch07_FACT database is shown below and should be used to answer the
next several problems. Click this image to view it in its own tab.
FIGURE P7.56 THE CH07_FACT ERD
CHECKOUT
PATRON
PK
Check Num
PK Pat ID
FK1 Book_Num
FK2 Pat_ID
Check_Out_Date
Check_Due_Date
Check_In_Date
>0-----H-
Pat_FName
Pat LName
Pat_Type
BOOK
AUTHOR
PK
Book_Num
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
The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT)
library of e-books. FACT is a collection of current technology e-books for use by faculty and
students. Agreements with the publishers allow patrons to electronically check out a book,

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.
Write a query to display the book title, price and publisher name for all books.
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's last name. (Figure P8.64)
Using F_STAFFS table, write a query that will display First_name and maximum salary of staffswith the column name “HighSalary”, whose first_name contain letter ‘u’, for eachFirst_Name, whose maximum salary is less than 10. Arrange it by Last_name from z to a.
Write a query to find the name of employees that begin with alphabet 'A'
Question 13 Write a query to display the last name, job of all employees whose last names starts with the letter "M".
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.
Write a query to display the trip name of all the trips that has Miles Abrams as guide. Sort your results in descending order according to the trip name.
Write a query to get the maximum and minimum salary from the senators table (in that order).
Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2015, and July 31, 2015.If a customer purchased more than one such product, display the customer's information only once in the output. Sort the output by state, last name, and then first name (Figure P7.32).