Question: SQL newbie, lost in the logic I need. I am solving: Display those customers who have checked out the same catalog item more than once.

SQL newbie, lost in the logic I need. I am solving: Display those customers who have checked out the same catalog item more than once. Show customer name, and for each catalog item show title, type,number of check out times, first check out date and last check out date for the item. Sort results by customer first/last name and catalog item title.

I can tell I have to join Customer to Library_Card to transaction in order to find out how many times a customer checked something out but I am making error SQL newbie, lost in the logic I need. I am solving: Display s left and right in getting the code correct for showing the number of times that customer checked out that particular item and I am having trouble with gettign the first check out date.

Branch Librery Branch ID NUMBER Library ID: NUMBER Branch Name: VARCHAR2(30) Branch-Phone VARCHAR2(30) te Branch Address: VARCHAR2(30) Library ID. NUMBER (FK) ???????????????????????? VARCHAR2(30 Librer-Name Library Phone: VARCHAR2(30) Library Address: VARCHAR2(30) Physical ltem Transacion Library Card Physical-ltem,ID: NUMBER Transaction-ID NUMBER Library_Card ID: NUMBER Branch ID NUMBER (FK) Catelog_ltem ID: NUMBER (FK) Copy Number NUMBER Date Purchased DATE Library ID: NUMBER (FK) Customer ID: NUMBER (FK) Card_Number VARCHAR2(30) PIN: VARCHAR2(8) Date Expire DATE Date checkout DATE Date Due: DATE Date Returned: DATE 6- Librery_Card_ID: NUMBER (FK) Physical ltem JD: NUMBER (FK) Catalog tenm Catalog-item-IO: NUMBER Customer Customer-iD: NUMBER Title: VARCHAR2(30) Description: VARCHAR2(30) Publisher VARCHAR2(30) Release Date: DATE Type: VARCHAR2(30) Customer Firstname: VARCHAR2(30) Customer Lastname: VARCHAR2(30) Customer Street VARCHAR2(30) Customer City VARCHAR2(30) Customer State: VARCHAR2(20) Customer Zip: VARCHAR2(10) Book DVD Catalog Item ID NUMBER (FK) Lenqth: VARCHAR2(30) Catalog-lternJD: NUMBER (FK) ISBN: VARCHAR213) Paqes: NUMBER

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create SQL statements for the following scenarios. Your response should include SQL statement, output and any other assumptions you have made to arrive at the solution. Please provide a single SQL...

Run the script DBST651_final_Part2_q2.sql attached and then respond the following SQL problems: Create SQL statements for the following scenarios. Your response should include SQL statement, output...

Create SQL statements for the following scenarios. 1. For each book in the catalog, display it's title, publisher, ISBN, release date, number of pages, and whether it's carried in any library ("Yes"...

lr EECH DUDE Jl'l THE CHIEF-DE}, lSpl-Ely" II'S TJIIE, |E|Il.llE|IliEil'lEf1 Iii-EN, I'EIE'EISE [IIEIIE1 Fl-Elf'l'lEF UT pages, and whether it's canied in any library ['\"i'es\" er "Me'ji. Sort...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

The Deliverables for the UML DIAGRAMS and DESCRIPTIONS Now you have Thortons original Project Description document as well as his Project Description Update document (available in the eConestoga...

Using the U.S. Securities and Exchange Commission?s EDGAR database, select a public company that has consolidated subsidiaries. To minimize the chances of classmates selecting the same company,...

I need help filling in an Exec Level report on a class. It is about the Airline Industry. We are focusing on buying American Airlines as if we are Delta Airlines. I just need assitance filling in the...

Complete class diagram (phase 5 and 6). 17 Questions. 17 To be submitted: 18 Marking Criteria. 20 Appendix A: Sample Output for a completed phase 6. 22 Objectives In this assignment you will develop...

Motion Music is doing a financial feasibility analysis for a new album. Recordings and production are estimated at $65.000. The printing of CDs is fixed at $5000 for set up plus S3 per CD. The...

A utility district has issued bonds totaling $4.7 Million with a fixed annual coupon rate of 4.00% and a term of 30 years. In addition to making the annual coupon payment, the district must deposit...

On September 1, 2025 the corporation acquired the brothers enterprise for a cash payment of $690000 at the time of the purchase brothers balance sheet showed assets of $620000 $240,000 and stock...

i need 5 7 7 . voltaic

Why do HCMSs exist? Do they change over time?

Suppose the price of oil falls sharply (as it did in 1986 and again in 1998). a. Show the impact of such a change in both the aggregate-demand/aggregate-supply diagram and in the Phillips-curve...

When did the shift from Text-based Business Application Software to GUI-based Applications begin?