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)

1.List all the authors, first name and last name in alphabetic order of first name.

2.List all the cities that have a publisher, list each city only once.

3.How many book titles are in the database?4.For each branch, list the branch name and the total number of books on hand.

5.How many employees total work at Henry Books?

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

One of the items reported as part of comprehensive income relates to foreign currency translation gains or losses. Describe the circumstances under which such gains/losses appear only in...

Andre Parker is a CFA charter holder, who works as an equity research analyst for an investment firm. During his spare time, Parker volunteers for City Pride, which collects used books for children...

Given the challenges of estimating cash flows, capital budgeting analysis typically ( ignores / uses ) cash flows that are expected to occur more than 1 0 years in the future.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

5. What are virtual expatriates? What are their advantages and disadvantages for the company and the manager?

4. What does the rigor of a cross-cultural training program refer to? What factors influence the level of training rigor needed?

5. Develop the succession planning review.