Write SQL queries for the Books database (discussed in Section 17.3) that perform each of the following tasks:
a) Select all authors from the Authors table.
b) Select all publishers from the Publishers table.
c) Select a specific author and list all books for that author. Include the title, copyright year and ISBN number. Order the information alphabetically by title.
d) Select a specific publisher and list all books published by that publisher. Include the title, copyright year and ISBN number. Order the information alphabetically by title.
a) SELECT * FROM Authors.
b) SELECT * FROM Publishers.
c) SELECT Authors.AuthorID, Titles.Title, Titles.Copyright,
Titles.ISBN, Authors.LastName,Authors.FirstName
FROM Titles, Authors, AuthorISBN
WHERE Authors.AuthorID = AuthorISBN.AuthorID
AND AuthorISBN.ISBN = Titles.ISBN
AND ((Authors.AuthorID) = 1)
ORDER BY Titles.Title.
d) SELECT Publishers.PublisherID, Publishers.PublisherName,
Titles.Title, Titles.Copyright, Titles.ISBN
FROM Publishers, Titles
WHERE Publishers.PublisherID = Titles.PublisherID
AND ((Publishers.PublisherID) = 2)
ORDER BY Titles.Title.
You might also like to view...
Answer the following questions true (T) or false (F)
1. A circumstance in C++ where an exception is thrown must be an error. 2. When an event occurs that cannot be managed locally, an exception may be thrown. Throwing the exception object transfers control and information gleaned locally to some calling program unit that manages the event, or the program terminates.
A function ______ tells the compiler the data type of the function, name of the function, and information about the arguments the function expects.
Fill in the blank(s) with the appropriate word(s).
Criteria that contain text must be surrounded by number signs
Indicate whether the statement is true or false
XHTML requires that all table headings be nested within the ________ element
A)