subject

Find products that satisfy BOTH conditions below:
(a) Its unit price must NOT below $22.
(b) Its category ID is 4 or 7 or 8. If its category ID is 1 or 3, then it must have at least 40 units in stock.
Display their Product ID, Unit Price, Category ID, and Units In Stock. The output should be sorted by Category ID in A -> Z order (i. e., from smallest to largest). For those with the same Category ID, the one with the highest Unit Price should be displayed first.
Hint 1: a compound condition with AND, OR, NOT.
Hint 2: correct output has 16 products.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 23:30
Which text format is this, "the text is transcribed exactly as it sounds and includes all the utterances of the speakers. "?
Answers: 2
question
Computers and Technology, 23.06.2019 06:00
What machine listens for http requests to come in to a website’s domain? a. a router b. a browser c. a server d. a uniform resource locator
Answers: 1
question
Computers and Technology, 24.06.2019 00:00
Afashion designer wants to increase awareness about her brand. which network can she use and why she can use the blank to blank her products online. answers for the first blank: internet, extranet, or intranet answers for the second blank: market, design, and export
Answers: 1
question
Computers and Technology, 24.06.2019 13:00
Which one of the following functions is not available on the autosum tool? sum average if max
Answers: 3
You know the right answer?
Find products that satisfy BOTH conditions below:
(a) Its unit price must NOT below $22.
Questions
question
Mathematics, 15.10.2019 22:10
question
Mathematics, 15.10.2019 22:10
Questions on the website: 13722360