# MCQ cis 2720 chapter 11.docx - MCQ’s CHAPTER 11 CIS

• 5

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 5 out of 5 pages.

MCQ’s CHAPTER 11 CIS 27201.A2.A3.D4.A5.A6.B7.D8.D9.D10. C11. B12. B13. B14. B15. D16. C17. C18. B19. C20. C1. Determine how manybooks are in the Cookingcategory.SELECT
'COOKING';2. Display thenumber of books with aretail price of more than\$30.00.SELECTCOUNT(*)FROMbooksWHERE retail >30;3. Display the mostrecent publication date ofall books sold by JustLeeBooks.SELECTMAX(pubdate)FROMbooks;4. Determine thetotal profit generated bysales to customer 1017.
Note: Quantity should bereflected in the total profitcalculation.SELECT
End of preview. Want to read all 5 pages?

Course Hero member to access this document

Term
Spring
Professor
YEE
Tags
Partially ordered set

Unformatted text preview: SUM((retail- cost)*quantity)FROM orders JOIN orderitems USING(order#) JOIN books USING(isbn)WHERE customer# = 1017; 5. List the retail price of the least expensive book in the Computer category. SELECT MIN(retail)FROM booksWHERE category = 'COMPUTER'; 6. Determine the average profit generated by orders in the ORDERS table. Note: The total profitby order must be calculated before finding the average profit. SELECT AVG(SUM((retail- cost)*quantity)) FROM orders JOIN orderitems USING(order#) JOIN books USING(isbn) GROUP BY order#;...
View Full Document