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

School College of DuPage
Course Title CIS 2720
Uploaded By maherazaidi7
Pages 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

Get answer to your question and much more

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

Upload your study docs or become a

Course Hero member to access this document

Term

Spring

Professor

YEE

Tags

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

Share this link with a friend:

Copied!

Other Related Materials

Newly uploaded documents

Nursing Care of Infants_and_Children-916.pdf

Nursing Care of Infants_and_Children-916.pdf

1

Class Exercise 1.1.docx

Class Exercise 1.1.docx

1

Which of the following is a fire tube boiler Option A Locomotive boiler Option B

Which of the following is a fire tube boiler Option A Locomotive boiler Option B

document

9

Commerce_Financial_Accounting-I__DC-1.pdf

Commerce_Financial_Accounting-I__DC-1.pdf

4

2339_Project_Management_Life_Cycle.docx

2339_Project_Management_Life_Cycle.docx

1

John Glen was the first American to A land on the moon B fly a plane C orbit the

John Glen was the first American to A land on the moon B fly a plane C orbit the

document

8

If the real exchange rate between the United States and Singapore is 1 then a

If the real exchange rate between the United States and Singapore is 1 then a

document

8

A UNIT 4 MCQs 1 In IEEE 80211 have three categories of a Frames b Fields c

A UNIT 4 MCQs 1 In IEEE 80211 have three categories of a Frames b Fields c

document

6

RESULTS A total of 1481 C chacoense plants in 28 populations 93 C baccatum

RESULTS A total of 1481 C chacoense plants in 28 populations 93 C baccatum

document

18

2-3 Journal.docx

2-3 Journal.docx

4

A special case of a collection is the class extent A class extent is the

A special case of a collection is the class extent A class extent is the

document

330

a comprehensive plan.docx

a comprehensive plan.docx

10

Copy of Module Five Honors Assignment.docx

Copy of Module Five Honors Assignment.docx

3

Page 71 of 150 Prefer Calling Sir Obiero Amos 0706 851 439 for Marking Schemes

Page 71 of 150 Prefer Calling Sir Obiero Amos 0706 851 439 for Marking Schemes

document

150

Be sure to give yourself short Be sure to give yourself short breaks and reward

Be sure to give yourself short Be sure to give yourself short breaks and reward

document

52

The assumption of the theory is that a firm does not operate in a perfect market

The assumption of the theory is that a firm does not operate in a perfect market

document

71

Remember that the wire has to generate a rate thats fast enough to make an

Remember that the wire has to generate a rate thats fast enough to make an

document

577

buisness growrh 1.docx

buisness growrh 1.docx

8

ENVIRO SCI MAC sem 1(1).pdf

ENVIRO SCI MAC sem 1(1).pdf

22

Setting the error rate to be 04 allows for 8 mismatches with the primer sequence

Setting the error rate to be 04 allows for 8 mismatches with the primer sequence

document

23

Document107.pdf

Document107.pdf

1

akash joshi presentation international law.pptx

akash joshi presentation international law.pptx

lecture

8

12 Republic of Nigeria 2014 The Police Act available in

12 Republic of Nigeria 2014 The Police Act available in

document

25

See more documents like this

Show More

Newly uploaded documents

1 pages

Nursing Care of Infants_and_Children-916.pdf

1 pages

Class Exercise 1.1.docx

9 pages

Which of the following is a fire tube boiler Option A Locomotive boiler Option B

document

4 pages

Commerce_Financial_Accounting-I__DC-1.pdf

1 pages

2339_Project_Management_Life_Cycle.docx

8 pages

John Glen was the first American to A land on the moon B fly a plane C orbit the

document

8 pages

If the real exchange rate between the United States and Singapore is 1 then a

document

6 pages

A UNIT 4 MCQs 1 In IEEE 80211 have three categories of a Frames b Fields c

document

18 pages

RESULTS A total of 1481 C chacoense plants in 28 populations 93 C baccatum

document

4 pages

2-3 Journal.docx

330 pages

A special case of a collection is the class extent A class extent is the

document

10 pages

a comprehensive plan.docx

3 pages

Copy of Module Five Honors Assignment.docx

150 pages

Page 71 of 150 Prefer Calling Sir Obiero Amos 0706 851 439 for Marking Schemes

document

52 pages

Be sure to give yourself short Be sure to give yourself short breaks and reward

document

71 pages

The assumption of the theory is that a firm does not operate in a perfect market

document

577 pages

Remember that the wire has to generate a rate thats fast enough to make an

document

8 pages

buisness growrh 1.docx

22 pages

ENVIRO SCI MAC sem 1(1).pdf

23 pages

Setting the error rate to be 04 allows for 8 mismatches with the primer sequence

document

1 pages

Document107.pdf

8 pages

akash joshi presentation international law.pptx

lecture

25 pages

12 Republic of Nigeria 2014 The Police Act available in

document

7 pages

Social Contexts of Adolescence.docx

Show More