Which of the following is a valid SQL statement? a. SELECT customer#, order#, MAX (shipdate-orderdate) FROM orders

Question:

Which of the following is a valid SQL statement?
a. SELECT customer#, order#, MAX (shipdate-orderdate)

FROM orders
GROUP BY customer#
WHERE customer# = 1001;

b. SELECT customer#, COUNT (order#)

FROM orders
GROUP BY customer#;

c. SELECT customer#, COUNT (order#)

FROM orders
GROUP BY COUNT (order#);

d. SELECT customer#, COUNT (order#)

FROM orders
GROUP BY order#;

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: