Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which…

Question

Options

• ASELECT cust_income_level || ` ' || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM
• BSELECT DISTINCT cust_income_level || ` ' || cust_credit_limit * 0.50 AS "50% Credit Limit"
• CSELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit"
• DSELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM

• A
  4% (1)
• B
  82% (23)
• C
  4% (1)
• D
  11% (3)

No community discussion yet for this question.