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.

Transcribed Image Text:

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

Answer rating: 100% (QA)

How many employees does Henry Books have SELECT COUNT AS TotalEmployees FROM ... View the full answer