Answer the following questions using SQL COMMANDS Queries to the Database Librar

Question

Answer the following questions using SQL COMMANDS

Queries to the Database Library

Author (AuthorId, Name, DOB)

Publisher (EditorId, Name, Address, CodPostal)

KEYWORD (WordId)

Book (ISBN, Title, Year, Edition, EditorId, share)

Authorbook (ISBN AuthorId)

Wordbook (ISBN WordId)

Exemplar (ExemplaryId, ISBN, RequestDate)

Reader (ReaderId, Name, Address, CodPostal, Location, Complement)

Request (RequestionId, ExemplaryId, ReaderId, RequestDate, PrevRequest date,

RealRequestDate, finevalue)

1. What are the codes of copies of the book with the title "Da Vinci Code"?

2. What are the titles of copies ordered alphabetically ordered in the month of january 2oo4

Explanation / Answer

1. What are the codes of copies of the book with the title "Da Vinci Code"?

SELECT P.CODPOSTAL FROM PUBLISHERS P WHERE EDITORID =(SELECT EDITORID FROM BOOKS WHERE TITLE = 'DA VINCI CODE')

2. What are the titles of copies ordered alphabetically ordered in the month of january 2oo4

SELECT B.TITLE FROM BOOKS B INNERJOIN ON EXEMPLAR E WHERE B.ISBN=E.ISBN AND E.REQUESTDATE LIKE 'JANUARY 2004'

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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