Multiple Choice
Contents of the ORDERS table
-Based on the contents of the ORDERS table,which of the following SELECT statements will determine the number of orders placed by each customer?
A) SELECT COUNT(DISTINCT(customer#) )
FROM orders;
B) SELECT COUNT(*)
FROM orders;
C) SELECT customer#,COUNT(customer#)
FROM orders
GROUP BY customer#;
D) none of the above
Correct Answer:

Verified
Correct Answer:
Verified
Q126: The _ clause is used to indicate
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
Q132: Which of the following is a valid
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