Solved

Contents of the ORDERS Table​

Question 131

Multiple Choice

Contents of the ORDERS table​
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
-​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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions