Multiple Choice
Which of the following is a valid statement?
A) The ORDER BY clause cannot be used in a SELECT statement containing a GROUP BY clause.
B) Data returned from a GROUP BY clause will automatically be sorted in descending order.
C) Column aliases cannot be used in a GROUP BY clause.
D) Columns referenced in the GROUP BY clause must also be contained in the SELECT clause.
Correct Answer:

Verified
Correct Answer:
Verified
Q127: The _ function is based upon the
Q128: The _ function is used to determine
Q129: If the data returned by the GROUP
Q130: The _ function returns the smallest value
Q131: Contents of the ORDERS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q133: Explain the difference between a WHERE and
Q134: Explain how nested group functions are processed.
Q135: If the DISTINCT keyword is not included
Q136: Functions that return one result per group
Q137: The STDDEV function can be used with