1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
inna [77]
3 years ago
6

Find products that satisfy BOTH conditions below:______

Computers and Technology
1 answer:
sammy [17]3 years ago
7 0

Answer:

Explanation:

--> First constraint should be satisfied.

UnitPrice>=22.

--> In Second and third either of one should be satisfied.

CategoryID in (4,7,8) OR (CategoryID in (1,3) AND UnitsInStock >= 40)

--> So, Final statement is :

SELECT ProductID, UnitPrice, CategoryID, UnitsInStock FROM Products

WHERE UnitPrice>=22 AND (CategoryID in (4,7,8) OR (CategoryID in (1,3) AND UnitsInStock >= 40))  

You might be interested in
Which of the following is a way the operating system prevents unknown or unauthorized users from accessing the system?
Xelga [282]

Put a code or security system on or a very secure password

Hope this helps...

6 0
3 years ago
Read 2 more answers
FS EVERFI:
Snowcat [4.5K]

Answer:

A) work study program

Explanation:

Because you need experience and scholarships don't always pay, so this is the best choice.

6 0
2 years ago
Read 2 more answers
32 what windows command can be used to copy entire directories, including subdirectories?
navik [9.2K]
Ctrl+a copies everything.
5 0
3 years ago
To make a drop shadow larger what should you change about the drop shadow in gimp
vlabodo [156]
To Change the Drop Shadow Just Go to effects on the photo go to drop shadow than change the spread and Distinse and Opasity.
4 0
3 years ago
Engine coolant does all of the following except
Amiraneli [1.4K]
D prevent the formation of rust
8 0
3 years ago
Read 2 more answers
Other questions:
  • Dr. Joon asks her students how to insert a table in an Excel workbook. The students record the steps a chart. Which students lis
    15·1 answer
  • A(n) _______________ supplies one of the most critical aspects of docking stations, but in a smaller, more portable format: supp
    15·1 answer
  • In the space below, write the formula that needs to be added to the blank cells under the fourth column of the table.
    13·1 answer
  • _____________ refers to know-what and know-why of technology.
    12·1 answer
  • What is the best use of a line chart? to show parts of a whole while emphasizing specific data to compare and contrast discrete
    9·2 answers
  • The camera still is bad even with the new iPhone xr and especially in low light it is even worst because you can see the pixels
    15·1 answer
  • Binary search takes a list of information and divides the list into two parts, one is divided and one is kept.
    15·1 answer
  • 4
    12·2 answers
  • We love silky. she is very honest join this by using conjunction ​
    11·2 answers
  • How do you enlarge an image to see more detail on it? (1 point)
    14·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!