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
Verdich [7]
4 years ago
9

1. Write a query to list the names all products (by product code and name) and the average ordered quantity for each product wit

h a product name that starts with 198 (if the product has never been ordered, then only show the product code and name). Order the result by ascending order of average ordered quantity.
Computers and Technology
1 answer:
r-ruslan [8.4K]4 years ago
8 0

select WorkCenterId, Count (ProducedIn_t.ProductID) as 'TotalProducts' from ProducedIn_t left outer join Product_t on Product_t.ProductID=Product_t.ProductID group by WorkCenterId

You might be interested in
What is the result of expression 15 > 10 > 5 in C? What is the result of the same expression in Java?
Inessa05 [86]

Answer:

java: error

C: false

Explanation:

In Java the compiler understand that you are trying to compare an integer (15) with a boolean (10 > 5) this generate the next error:

error: bad operand types for binary operator  

In C the compiler convert (15 > 10 > 5) in (15>10) > (10>5) which is equal to TRUE > TRUE, the compiler can also read it as 1 > 1 (since 1 is TRUE and 0 is FALSE).  like 1>1 is false then C program return false.

5 0
3 years ago
Supervisor: You will need to consolidate your trouble tickets
liubo4ka [24]
Wheres the rest???????????????????
7 0
3 years ago
Two files named numbers1.txt and numbers2.txt both have an unknown number of lines, each line consisting of a single positive in
Reika [66]

Answer:

see explaination for program code

Explanation:

scalar_product = 0

li=[]

li2=[]

#reading numbers1.txt and numbers2.txt intoli and li2 respectively

with open('numbers1.txt') as n1, open('numbers2.txt') as n2:

for line1 in n1:

li.append(int(line1))

for line2 in n2:

li2.append(int(line2))

#storing min list size into variable l

a=len(li)

b=len(li2)

if a<b:

l=a

else:

l=b

#calculating scalar product

for i in range(l):

scalar_product=scalar_product+li[i]*li2[i]

print("scalar product is",scalar_product)

6 0
4 years ago
If a menu item requires additional information from the user, the Windows standard is to place a(n) ____ at the end of the capti
elena-s [515]

Answer:

elipses

Explanation:

According to my research on information technology, I can say that based on the information provided within the question the windows standard in this situation would be to place an ellipses at the end of the caption. This is because in the English language an ellipses (...)  usually indicates an intentional omission of a word or sentence, which in computer science is used to give the user an indication that it requires further user input.

I hope this answered your question. If you have any more questions feel free to ask away at Brainly.

4 0
4 years ago
Speed and security are advantages generally associated with this type of network. wired wireless
Gennadij [26K]

Answer:

The answer to the given question is "Wired".

Explanation:

In this question, the answer is wired because A wired means cables that are used to connect system like a laptop or a desktop to the Internet or another network.

  • wired network uses cables that's why the speed and security of the wired network are high.
  • In wireless It allows devices to stay connected to the network and It is less secure to the wired.

That's why the answer is "Wired".

4 0
3 years ago
Other questions:
  • How are information systems used at the industry level to achieve strategic advantage? By enforcing standards that reduce the di
    8·1 answer
  • Suppose you have an int variable called number. What Java expression produces the second-to-last digit of the number (the 10s pl
    13·1 answer
  • Ruby is creating a presentation. She wants each slide displayed at intervals of five seconds. Which feature in the presentation
    6·2 answers
  • Technician A says that a cracked exhaust manifold can affect oxygen sensor operation. Technician B says that a clogged air filte
    7·1 answer
  • What component of a processor handles all logical comparisons and calculations inside the processor?
    9·1 answer
  • How do you join The Meeting on zoom because I have class Tomorrow with My Teacher
    7·2 answers
  • so i am on a Chromebook with headphones , and I am wondering if you can make it that a tab only play sound on one side of the he
    12·1 answer
  • What does error code 18 indicate?
    11·1 answer
  • _____ have networked and texted all of their lives with smartphones, tablets, and high-speed Internet.
    8·1 answer
  • How do you answer other peoples questions on Brainly? I know how to ask them but not answer hmm...
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!