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
zysi [14]
3 years ago
12

Write a SELECT statement that returns these columns from the Products table: The list_price column The discount_percent column A

column named discount_amount that uses the previous two columns to calculate the discount amount and uses the ROUND function to round the result so it has 2 decimal digits Use column aliases for any columns that contain a function or a formula.
Computers and Technology
1 answer:
Anarel [89]3 years ago
6 0

Answer:

Check the explanation

Explanation:

The SELECT statement that returns these columns are:

SELECT

   list_price,

   discount_percent,

   ROUND (list_price * discount_percent / 100,2)  AS discount_amount

FROM

   products;

----------------------------------------------------------------------

You might be interested in
In the code snippet, what is the “win” part called in programming?
MAXImum [283]
I think the answer is B: parameter
8 0
3 years ago
Write a one-line program to output the following haiku.
Serggg [28]

10 CLEAR: PRINT "A lightning flash: between the forest trees I have seen water.": END

8 0
3 years ago
Read 2 more answers
What can Strings store
horsena [70]
A string is generally considered as a data type and is often implemented as an array data structure of bytes (or words) that stores a sequence of elements, typically characters, using some character encoding. String may also denote more general arrays or other sequence (or list) data types and structures.
5 0
4 years ago
Read 2 more answers
What is ‘Software Quality Assurance’?
Aleonysh [2.5K]

Answer: Software quality assurance is considered as the means under which one monitors the software processes and techniques used in order to ensure quality. The techniques using which this is attained are varied, and thus may also include ensuring accordance to more than one standards. It is referred to as a set of techniques that ensures the quality of projects in software process. These mostly include standards that administrators use in order to review and also audit software activities, i,e, these software meet standards.

5 0
3 years ago
How do I attach a file on the computer?
strojnjashka [21]
When you select 'ask your question' a box will appear and it will ask you to write your question. Underneath the text box you'll see a 'pi' sign and an 'omega' sign and next to that you'll see a paperclip sign. Click the paperclip sign and then choose the file/s you want to attach.

I have attached a docx (document) if you don't get what i mean.
Hope it helped :)
Download docx
4 0
3 years ago
Other questions:
  • Where can you access all the formatting options for worksheet cells?
    5·1 answer
  • A customer has a system with a Gigabyte B450 Aorus Pro motherboard. He wants to upgrade the processor from the AMD Athlon X4 950
    8·2 answers
  • Which of the following statements about certificates is true?
    14·2 answers
  • Henry created a software that manages all of his music. He wishes to run software on another computer system that runs an operat
    8·1 answer
  • What is an unknown network called
    6·1 answer
  • How is a technical certificate like a computer-related associate degree?
    12·2 answers
  • Which two of the following skills are important for a meteorologist
    12·1 answer
  • True or False: Variablename must start with a number.
    13·1 answer
  • Any one know??please let me know
    15·2 answers
  • ____ can be used to break continuous text to one or more sentences​
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!