What information has to be provided in the GROUP BY list?

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

View Answer

Answer: A