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
maw [93]
3 years ago
10

Write a query to show the price reduced by 10% for all products that are tables or entertainment centers with a standard price g

reater than or equal to $200. Show the discounted price under the heading "Sale Price". Order the results by increasing price.
Computers and Technology
1 answer:
IceJOKER [234]3 years ago
8 0

Answer:

Below is the required code:

Explanation:

SELECT Product_Finish AS "Desk Finish",

avg(Standard_Price) AS "Average Price"

FROM Product_T

WHERE "Average Price">200

ORDER BY "Average Price" DESC;

You might be interested in
What is the output of the following code snippet? int i = 1; while (i != 9) { System.out.print(i + " "); i++; if (i == 9) { Syst
Monica [59]

Answer:

1 2 3 4 5 6 7 8 End

Explanation:

int i = 1;

while (i != 9){

  System.out.print (i + " ");

  i ++;

  if (i == 9){

     System.out.println("End");

  }

}

7 0
2 years ago
Exercise 8.1.9: Diving Contest Your school is hosting a diving contest, and they need a programmer to work on the scoreboard! Yo
vampirchik [111]

Answer:

def calculate_score(theTuple):

    first, second, third = theTuple

    if first >= 0 and first <=10 and second >= 0 and second <=10 and third >= 0 and third <=10:

         print(first + second+third)

    else:

         print("Range must be 0 to 10")

Explanation:

This line defines the function

def calculate_score(theTuple):

This line gets the content of the function

    first, second, third = theTuple

The following if condition checks if the digits are in the range 0 to 10

    if first >= 0 and first <=10 and second >= 0 and second <=10 and third >= 0 and third <=10:

This calculates the sum

         print(first + second+third)

else:

If number is outside range 0 and 10, this line is executed

         print("Range must be 0 to 10")

4 0
3 years ago
Which of the following are common data types? Check all that apply.
aliya0001 [1]

Answer:

integers

booleans

characters

floating-point numbers

alphanumeric strings

Explanation:

7 0
3 years ago
df -h shows there is space available but you are still not able to write files to the folder. What could be the issue
Rzqust [24]

The possible issue when df-h shows that there is space available is that;

It Ran out of inodes

<h3>What is a Linux System?</h3>

The correct reason is that it ran out of nodes in Ubuntu which is an open source operating system on Linux

Now,  In a "vanilla" installation, if you have too many small files, they can consume inodes, but not space. However, you will observe that you have available space, but since your inodes are full, you'll not be able to use this space.

Read more about Linux System at; brainly.com/question/25480553

5 0
2 years ago
Which computer discipline involves the widest scope of computer-related
noname [10]

Answer: D, computer science

Explanation: Computer engineering is a specific field of computer science, as well as B and Software Engineering

5 0
2 years ago
Read 2 more answers
Other questions:
  • What computer has best software
    5·1 answer
  • How many answer or point do I answer/need to sent message?
    6·1 answer
  • Write a method called swapPairs that switches the order of values in an ArrayList of strings in a pairwise fashion. Your method
    9·1 answer
  • What date of us can be used on a desktop computer
    12·1 answer
  • Identify the benefit of modeling to communicate a solution. ​
    11·2 answers
  • In which circumstances would the view side by side feature be useful or helpful.
    15·2 answers
  • Write a program that prompts the user to enter a number then counts the number of odd numbers and even numbers the user enter. T
    15·1 answer
  • Describe all the steps a router goes through while deciding where to send the a packet. Explain why a router would choose one ro
    7·1 answer
  • Will this website ever get itself together to stop people from sending links?
    9·1 answer
  • What is the difference between a LAN and WAN? how do these two networks interact?​
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!