Question: SQL Help, I am new to SQl and trying to solve: For a book with ISBN 9780756404079, display its title, publisher, ISBN, which library (not

SQL Help, I am new to SQl and trying to solve:

For a book with ISBN 9780756404079, display its title, publisher, ISBN, which library (not branch) has it, and total number of copies each library has. Do not show libraries that dont carry it. Sort results by number of copies in decending order.

I tried:

Select Catalog_Item.Title,(select count(*) from book) as Number_of_Copies, Catalog_Item.publisher, Book.isbn, Library_Name

from catalog_Item, Library,book

where catalog_Item.catalog_Item_ID = Book.catalog_Item_ID and book.isbn = 9780756404079

order by Number_of_copies desc;

But it is only listing one book and the libraries that carry it, what do I fix? SQL Help, I am new to SQl and trying to solve: For

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

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"...

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

Give me the all the coding code and all the project vb files(if can) You are required to write a full program code for Library Management System based on the information provided ReadOBrite Public...

I have this code , it can be running but no output produced. So, i attach the question as your reference. Output: Program did not output anything! Please help me solve this.. i need to submit my...

I have this code but it cant be running..it got error. The error like this : error: can't find main(String[]) method in class: Library Please help me solve this.. i need to submit my coding ASAP....

This is a class project. I tried as best as I could to copy and paste the instructions from microsoft word. please ask me if you need any more clarifications on the specifics. Programming Project 1...

I have this code , it can be running but no output produced. So, i attach the question as your reference. Output: Program did not output anything! Please help me solve this.. i need to submit my...

Determine if the following FIR systems are minimum phase (a) h(n) = (10, 9.-7.-8.0.5. 3} (b) hin) = 15.4,-3.-4.0. 2.1)

A cricket team captain wants to have 9 players at two sets of fielding positions - one for each of the current left-handed - right-handed pair of batsmen. It doesn't matter which player is at which...

Dollar cost averaging helps investors avoid the pitfall of buying high and selling low. True False

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+Trainers from headquarters? Local trainers? Independent trainers?

=+j What are the effects of language differences? Will there be translation problems (for both written and orally presented materials)? Are there differences in the meanings of words? Are there terms...

=+foreign language(s)? Who should take responsibility (headquarters personnel, host-country specialists, or third-party vendors) for translation? Should