In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value.
What information has to be provided in the GROUP BY list?
A . The CASE statement as provided in the SELECT list without its alias
B . The alias of the CASE construct used in the SELECT list
C . None; the GROUP BY list is added automatically
D . The name of the gross amount column that is used in the CASE statement
Answer: A