Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How many employees does Henry Books have? What is the most expensive book? List the price and the title aspart of the output. For each

How many employees does Henry Books have?

What is the most expensive book? List the price and the title aspart of the output.

For each type of book, list the type and the average price forthose books whose average price is greater than $5.00

List the book code, book title, and price of each book with aprice greater than or equal to $15 and less than or equal to $25(show the SQL code with the BETWEEN and without BETWEEN)

List the book code and book title of each book that has the typeMYS and a price of less than $20

Customers who are part of a special program get a 10 percentdiscount off regular book prices. List the book code, book title,and discounted price of each book. Use DISCOUNTED_PRICE as the namefor the computed column.

List the book code and book title of each book that has the typeSFI, MYS, HOR (show the SQL code with the IN and without IN).

For each book, list the book code, book title, publisher code,and publisher name. Order the results by publisher name.

For each book published by Scribner, list the book code, booktitle and price.

List the book title for each book that has type PSY and ispublished by Berkley publishing.

imageimageimageimageimage

BRANCH BRANCH_NUM BRANCH_NAME PUBLISHER AH AP PUBLISHER_CODE PUBLISHER_NAME Arkham House Arcade Publishing Basic Books BA BP BY CT FA FS 1 Henry Downtown 2 Henry On The Hill 3 Henry Brentwood 4 Henry Eastshore HC JP JT LB MP PE PL PU RH SB SC SS ST TB TH TO VB WN WP BRANCH_LOCATION NUM_EMPLOYEES 16 Riverview 1289 Bedford Brentwood Mall Eastshore Mall Berkley Publishing Back Bay Books Course Technology Fawcett Books Farrar Straus and Giroux HarperCollins Publishers Jove Publications Jeremy P. Tarcher Lb Books McPherson and Co. Penguin USA Plume Putnam Publishing Group Random House Schoken Books Scribner Simon and Schuster Scholastic Trade Taunton Press Tor Books Thames and Hudson Touchstone Books Vintage Books W.W. Norton Westview Press CITY Sauk City WI New York Boulder CO Boston New York Boston New York New York New York New York Los Angeles New York Kingston New York New York New York New York New York New York New York New York Newtown CT New York New York Westport CT New York New York Boulder CO 10 6 15 9 AUTHOR AUTHOR_NUM AUTHOR_LAST AUTHOR_FIRST 1 Morrison 2 Solotaroff 3 Vintage 4 Francis 5 Straub 6 King 7 Pratt 8 Chase 9 Collins 10 Heller 11 Wills 12 Hofstadter 13 Lee 14 Ambrose 15 Rowling 16 Salinger 17 Heaney 18 Camus 19 Collins, Jr. 20 Steinbeck 21 Castelman 22 Owen 23 O Rourke 24 Kidder 25 Schleining Toni Paul Vernor Dick Peter Stephen Philip Truddi Bradley Joseph Gary Douglas R. Harper Stephen E. J.K. J.D. Seamus Albert Bradley John Riva Barbara Randy Tracy Lon BOOK BOOK_CODE TITLE 0180 0189 0200 0378 079X 0808 1351 1382 138X 2226 2281 2766 2908 3350 3743 3906 5163 5790 6128 6328 669X 6908 7405 7443 7559 8092 8720 9611 9627 9701 9882 9883 9931 A Deepness in the Sky Magic Terror The Stranger Venice Second Wind The Edge Dreamcatcher: A Nvel Nine Stories The Soul of a New Machine Travels with Charley Catch-22 Treasure Chests Beloved Harry Potter and the Prisoner of Azkaban Van Gogh and Gauguin WP Of Mice and Men PE Electric Light FS Group: Six People in Search of a BP Life Jazz Band of Brothers A Guide to SQL Franny and Zooey East of Eden Harry Potter and the Goblet of Fire PUBLISHER TYPE PRICE PAPERBACK CODE The Fall Godel, Escher, Bach When Rabbit Howls Black House Song of Solomon The Grapes of Wrath Slay Ride The Catcher in the Rye To Kill a Mockingbird TB FA VB SS PU JP SC PL ST LB BY PE SC PL TO CT LB PE ST VB BA JP RH PL PE JP LB HC SFI $7.19 Y HOR $7.99 Y FIC $8.00 Y ART $24.50 N MYS $24.95 N MYS $6.99 Y HOR $19.60 N ART $24.46 N FIC $12.95 Y SFI $13.96 N ART $21.00 N FIC $6.95 Y POE $14.00 N PSY $10.40 Y FIC $5.99 Y SCI $11.16 Y TRA $7.95 Y $12.00 Y $12.95 Y HIS $9.60 Y CMP $37.95 Y FIC $5.99 Y FIC $12.95 Y SFI $18.16 N FIC FIC FIC $8.00 Y PHI $14.00 Y $6.29 Y PSY HOR $18.81 N FIC $14.00 Y $13.00 Y $6.99 Y $5.99 Y $18.00 N FIC MYS FIC FIC WROTE BOOK_CODE AUTHOR_NUM SEQUENCE 0180 0189 0200 0378 079X 0808 1351 1382 1382 138X 2226 2281 2281 2766 2908 3350 3743 3 5 18 11 4 4 6 23 25 1 15 9 19 20 17 2 16 1 1 1 1 1 1 1 2 1 1 1 2 1 1 1 1 1 INVENTORY BOOK_CODE BRANCH_NUM ON_HAND 0180 0189 0200 0200 0378 079X 079X 079X 0808 1351 1351 1382 138X 2226 2226 2226 2281 1 2 1 2 3 2 3 4 2 2 3 2 2 1 3 ++ 4 4 2 2 1 3 2 1 2 3 1 4 2 1 3 3 2 1 3 WROTE BOOK_CODE AUTHOR_NUM SEQUENCE 3906 5163 5790 6128 6328 669X 6908 7405 7443 7559 8092 8720 9611 9611 9627 9701 9882 9883 9931 24 20 10 1 14 7 16 20 15 18 12 8 5 6 1 20 4 16 13 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 INVENTORY BOOK_CODE BRANCH_NUM ON HAND 2766 2908 2908 3350 3743 3906 3906 5163 5790 6128 6128 6328 669X 6908 7405 7443 7559 8092 8720 9611 9627 9627 9701 9701 9701 9701 9882 9883 9883 9931 3 1 4 1 2 2 3 1 4 2 3 2 1 2 3 4 2 3 1 1 3 4 1 2 3 432 4 1 2 3 1 2 1 1 2 1 2 4 3 2 1 2 2 1 2 1 3 2 5 2 2 1 3 2 3 3 2 2

Step by Step Solution

3.54 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

How many employees does Henry Books have SELECT COUNT AS TotalEmployees FROM ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

More Books

Students also viewed these Programming questions

Question

Write short notes on Interviews.

Answered: 1 week ago

Question

Define induction and what are its objectives ?

Answered: 1 week ago

Question

Discuss the techniques of job analysis.

Answered: 1 week ago

Question

How is a user password assigned in Oracle 11g?

Answered: 1 week ago