Question: Write sql statement to answer following questions Author( AuthorNum, AuthorLast, AuthorFirst) Book( BookCode, Title, PublisherCode, Type, Price, Paperback) Branch(BranchNum, BranchName, BranchLocation, NumEmployees) Inventory(BookCode, BranchNum, OnHand)

Write sql statement to answer following questions

Author( AuthorNum, AuthorLast, AuthorFirst) Book( BookCode, Title, PublisherCode, Type, Price, Paperback) Branch(BranchNum, BranchName, BranchLocation, NumEmployees) Inventory(BookCode, BranchNum, OnHand) Publisher(PublisherCode, PublisherName, City) Wrote(BookCode, AuthorName,Sequence)

6.List the titles of all of the books written by Stephen King.

7.List title, type and price for all books that are paperback.

8.List the branch name for all branches that have at least one book that has at least 10 copies on hand.

9.For each book, list the title, author first name and author last name. Print the list in reverse alphabetic order of the title.

10. List each publisher by name and how many books they published.

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!

Write sql statement to answer following questions Author( AuthorNum, AuthorLast, AuthorFirst) Book( BookCode, Title, PublisherCode, Type, Price, Paperback) Branch(BranchNum, BranchName,...

Write SQL statement and run against the table and books database. /*** WITH ALTER ***/ ------------------------------------------------ -- Drop all the schema....

The purpose of this assignment is to familiarize with PHP Queries. Write PHP Query for each of the following queries (q1.php, q2.php, ...) and test them on the Henry Books database (tables and...

write the SQL statement (query) and Run the query against the tables in the book database. /*** WITH ALTER ***/ ------------------------------------------------ -- Drop all the schema....

write the SQL statement and run against the tables in the book database /*** WITH ALTER ***/ ------------------------------------------------ -- Drop all the schema....

weite the SQL statement (query) and run against the Book database. Q1. List the book code for books without a title Q2. List the count of distinct book types. Q3. List the distinct book type and...

Find the input voltage of the given circuit .given that the maximum Power drawn is 200mw.

Prove that if f (0) = g(0) and f(x) g(x) for x 0, then f (x) g(x) for all x 0.

. The key to a CDO s viability is the creation of a structure with a competitive return for the: A . senior tranche. B . mezzanine tranche. C . subordinated tranche.

where did we find that QD is 1 . 5 1 3 ?

Explain why the following statements are false. a. The aggregate-demand curve slopes downward because it is the horizontal sum of the demand curves for individual goods. b. The long-run...

Suppose that the economy is currently in a recession. If policymakers take no action, how will the economy change over time? Explain in words and using an aggregate-demand/ aggregate-supply diagram.

Suppose the U.S. economy begins in long-run equilibrium. Concerns about global climate change cause the government to significantly restrict the production of electricity from fossil fuels. Because...