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)

11. How many books cost less than $10.00?

12. List the author last names for all the authors published by Simon and Schuster.

13. List each type of book and how many of each.

14. How many books are on hand at the Brentwood Mall location?

15. List each branch location, the number of employees and the number of books on hand.

16. List the titles of all books who have a Sequence number of 1. You must use a nested select statement.

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

In the accompanying graph, is the slope of curve AA positive or negative? Does the slope increase or decrease as we move along the curve from A to A? Answer the same two questions for curve BB. A' B '

Stagg Advertising Companys trial balance at December 31 shows Supplies $8,800 and Supplies Expense $0. On December 31 there are $1,100 of supplies on hand. Prepare the adjusting entry at December 31...

Comparing two companies ratios 2 . 1 0 : 1 versus 1 . 3 5 : 1

29 The diene lactone shown in part (a) has one electron-donating group ( OR ) and one electron-withdrawing group (C=O). This diene lactone is sufficiently electron-rich to serve as the diene in a...

KEY QUESTION Describe the major provisions of the Sherman and Clayton acts. What government entities are responsible for enforcing those laws? Are firms permitted to initiate antitrust suits on their...

LAST WORD Under what law and on what basis did the Federal district court find Microsoft guilty of violating the antitrust laws? What was the initial district courts remedy? How did Microsoft fare...

KEY QUESTION Suppose a tax is such that an individual with an income of $10,000 pays $2000 of tax, a person with an income of $20,000 pays $3000 of tax, a person with an income of $30,000 pays $4000...