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)

17. List all the publishers whose name starts with T.

18. List all of the Author information for all authors that have a double l in their name (ll).

19. List all the book titles that have a book code of 079x, 138x or 669x.

20. List each author last name, book title and publisher name, in alphabetic order of the publisher.

21. Choose any 2 of the above, and write the SQL statements differently. (10 points)

22. Looking at the tables, figure out another type of information a person who worked at Henry Books might be interested in. Write the question and the query and results to answer the question. (10 points)

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

Problem 2. (Diagonal Entry in Wishart Random Matrix) For px p random matrix M ~ W(, m), prove the following results. 1) Show that, for any constant vector a 0, we have: a'Ma a' Ea ~ Xm i=1 Hint:...

Draw the full decision tree for the parity function of four Boolean attributes, A, B, C, and D. Is it possible to simplify the tree?

An asset's cost is $ 6 0 , 0 0 0 with an estimated residual value of $ 1 0 , 0 0 0 and useful ife of 1 0 years. At the end of the assets useful ife, its book for carryingl value equals $ 5 0 . 0 0 0...

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

=+derived from the assignment will balance the costs?

=+1 What type of adjustment (differential) will they need to pay to make up for the

=+6 Who is the peer of the IA ?