Henry Books Database assignment_3

DOCUMENT INFO
Shared By:
Categories:
Stats:
views:4889
posted:3/23/2011
language:English
pages:4
Description: Henry Books Database assignment_3 My Sql CITD 120 1. (2 points) For each book, list he book code, book title, publisher code, and publisher name. Sort the results by publisher name. Within publisher name order the books by title. 2. (2 points) Find the book title for each book written by author number 18. Use the IN operator. 3. (2 points) Find the book title for each book written by author number 18. Use the EXISTS operator. 4. (2 points) Find the book code and book title for each book located in branch number 2 that is written by John Steinbeck. Do not use IN or EXISTS.C:\LCC\2010Fall\CITD120\Assignments\Fall-6\CITD120Fa-Assign4.doc 5. (2 points) List the book codes and title for each pair of books that have the same price. The first book code listed should be the major sort key. The second book code listed should be the minor sort key. Choose column names that make it clear which title is associated with which book code. 6. (2 points) List the book code and book title for each book whose price is more than $10 or that was published in Boston. Use a UNION. Sort by title. 7. (1 points) List the book code and book title for each book whose price is more than $10 or that was published in Boston. Do not use a UNION. Sort by title. 8. (2 points) Find the book code and book title for each book whose price is greater than the price of at least one book that has the type HOR. Use ANY or ALL. Note: You must choose ANY or ALL based upon the requirements of the query. Only one choice is correct. 9. (1 points) Find the book code and book title for each book whose price is greater than the price of at least one book that has the type HOR. Do not use ANY or ALL. 10. (4 points) List the book code, book title, and branch name for each book where there are fewer on hand than the book 'Beloved'. Use ANY or ALL. Note: You must choose ANY or ALL based upon the requirements of the query. Only one choice is correct.