1. List the name of each publisher that is not located in New York. mysql> select editor name from editor -> where city != “new york” ++ | publisher name | ++ | arkham house | | basic books | | berkley editorial | | technology course | | Jeremy P. jar | | mcpherson and company | | taunton press | | touchstone books | | westview press | ++ 9 rows in set (0.00 sec)2. List the title of each book published by Penguin USA. select book title, publisher where book.publishercode = publisher.publishercode and publishername = “penguin usa”
+-+ | title | ++ | of mice and men | | travels with charley | | east of eden | | the grapes of wrath | ++ 4 rows in set (0.00 sec)3. List the title of each book that has type mys. mysql> select book title -> where type = “my”; ++ | title | ++ | second wind | | the edge | | kill ride | ++ 3 rows in set (0.00 sec)4. list the title of each book that has the type sfi and is in paperback. select book title where type = “psi” and paperback = “yes” ++ | title | ++ | group: six people in search of a life | | when the rabbit howls | ++ 2 rows in set (0.01 sec)5. List the title of each book that has type psy or whose publisher code is jp. mysql> select book title -> where type = “psy” or editor code = “jp”; ++ | title | ++ | the edge | | group: six people in search of a life | | when the rabbit howls | | kill ride | ++ 4 rows in set (0.00 sec)6. List the title of each book that has the type cmp, his, or sci. select the book title where type = “cmp” or type = “his” or type = “sci”
You are reading: Henry books sql answers
+-+ | title | ++ | the soul of a new machine | | band of brothers | | a guide to sql | ++ 3 rows in set (0.00 sec)7. how many books have an editor code of st or vb? select count(*) as bookspubstorvb from book where publishercode = “st” or publishercode = “vb”
See Also: Classic Children&039s Books Preschool Lesson Plans – Stay At Home Educator
+-+ | bookpubtorvb | ++ | 4 | ++ 1 row in set (0.00 sec)8. List the title of each book written by Dick Francis. select book title, author, wrote where book.bookcode = wrote.bookcode and author.num = wrote.authornumber and authorlast = “francis” and authorfirst = “dick”
+-+ | title | ++ | second wind | | the edge | | kill ride | ++ 3 rows in set (0.00 sec)9. List the title of each book that has the fic type and was written by John Steinbeck. select book title, author, wrote where book.bookcode = wrote.bookcode and author.authornumber = wrote.authornumber and authorlast = “steinbeck” and authorfirst = “john” and type = “fic”
+-+ | title | ++ | of mice and men | | east of eden | | the grapes of wrath | ++ 3 rows in set (0.00 sec)10. For each coauthored book, list the title, publisher code, type, and authors’ names (in the order they appear on the cover). select concat(authorlast,””, “,authorfirst) as author, title, publisher code, author type, wrote, book where author.authornumber = wrote.authornumber and book.bookcode = wrote.bookcode and wrote.bookcode in ( select bookcode group written by book code with count(*) >= 2 ) order by book code written, asc sequence;
See Also: 10 Best Mentoring Books to Read in 2022
+-+-+-+-+ | author | title | editorial code | type | +-+-+-+-+ | morrison, toni | harry potter and the prisoner of azkaban | st | sfi | | Rowling, J. k. | harry potter and the prisoner of azkaban | st | sfi | | collins, jr., bradley | van gogh and gauguin | keyword | art | | collins, bradley | van gogh and gauguin | keyword | art | | King Stephen | black house | right | hour | | straub, pedro | black house | right | hour | +-+-+-+-+ 6 rows altogether (0.01 sec)11. How many copies of books are priced at more than $20 but less than $25? select count(*) as book20to25 from copy where price > 20 and price < 25
+-+ | book20to25 | ++ | 6 | ++ 1 row in set (0.00 sec)12. Please list the branch number, copy number, quality and price of each copy of the stranger. mysql> select branchnum, copynum, quality, copy price, book -> where book.bookcode = copy.bookcode -> y title = “the stranger”; +-+-+-+-+ | branchnum | copy | quality | price | +-+-+-+-+ | 1 | 1 | excellent | 8 | | 2 | 1 | excellent | 8 | | 2 | 2 | fair | 4 | | 2 | 3 | poor | 2 | +-+-+-+-+ 4 rows altogether (0.00 sec)13. Please list the name of the branch, the copy number, the quality and the price of each copy of electric light. select branch name, copy number, quality, copy price, book, branch where book.bookcode = copy.bookcode and branch.branchnumber = copy.branchnumber and title = “electric light”
+-+-+-+-+ | branch name | copy | quality | price | +-+-+-+-+ | henry center | 1 | excellent | 15 | | henry center | 2 | excellent | 15 | | henry center | 3 | good | 9 | | henry east coast | 1 | good | 9 | +-+-+-+-+ 4 rows altogether (0.00 sec)14. For each book copy priced over $25, please list the title, quality, and price of the book. mysql> select title, quality, book price, copy -> where book.bookcode = copy.bookcode -> and price > 25; +-+-+-+ | title | quality | price | +-+-+-+ | second wind | excellent | 26 | | second wind | excellent | 26 | | second wind | excellent | 26 | | second wind | excellent | 26 | | treasure chests | good | 35 | | a guide to sql | excellent | 40 | | a guide to sql | excellent | 40 | +-+-+-+ 7 rows altogether (0.00 sec)15. For each excellent quality copy of a book available from Henry on the Hill Branch, please list the title of the book and the names of the authors (in the order listed on the title page). select title as “great books at henry on the hill”, concat (author last, “, “, author first) as author from author, wrote, book where author.authornumber = wrote.authornumber and book.bookcode = wrote.bookcode And wrote. bookcode in (select write.bookcode from branch, copy, write where branchname = “henry on the hill” and quality = “excellent” and copy.branchnum = branch.branchnum group by write.bookcode) sort by write.bookcode, asc sequence
+-+-+ | excellent books in henry on the hill | author | +-+-+ | a depth in the sky | vintage, vernor | | magical terror | straub, pedro | | the stranger | alberto camus | | venice | wills, gary | | second wind | Francis, cock | | the edge | Francis, cock | | dreamcatcher: a novel | King Stephen | | treasure chests | o.rourke, randy | | beloved | schleining, lon | | harry potter and the prisoner of azkaban | Rowling, J. k. | | harry potter and the prisoner of azkaban | morrison, toni | | van gogh and gauguin | collins, jr., bradley | | van gogh and gauguin | collins, bradley | | of mice and men | steinbeck, john | | electric light | heaney, seamus | | group: six people in search of a life | solotaroff, paul | | nine stories | Salinger, J. d. | | the soul of a new machine | joker, tracy | | travels with charley | steinbeck, john | | capture-22 | heller, jose | | jazz | morrison, toni | | band of brothers | Ambrose, Stephen E. | | a guide to sql | pratt, philip | | Franny and Zooey | Salinger, J. d. | | east of eden | steinbeck, john | | harry potter and the goblet of fire | Rowling, J. k. | | the fall | alberto camus | | godel, escher, bach | Hofstadter, Douglas R. | | when the rabbit howls | chase, truddi | | black house | King Stephen | | black house | straub, pedro | | song of solomon | morrison, toni | | the grapes of wrath | steinbeck, john | | kill ride | Francis, cock | | the catcher in the rye | Salinger, J. d. | | to kill a mockingbird | lee, harpist | +-++-+ 36 rows altogether (0.05 sec)
See Also: Sách Beezus Và Ramona – FAHASA.COM