View the Exhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compensation paid to each employee to date. You issue the following query: What is the…

Question

Exhibits

Options

• AIt generates an error because the alias is not valid.
• BIt executes successfully and gives the correct output.
• CIt executes successfully but does not give the correct output.
• DIt generates an error because the usage of the ROUND function in the expression is not valid.
• EIt generates an error because the concatenation operator can be used to combine only two items.

• A
  2% (1)
• B
  13% (7)
• C
  74% (39)
• D
  4% (2)
• E
  8% (4)

Explanation

ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are

No community discussion yet for this question.