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.

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#;

Step by Step Solution

3.56 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

b SELECT cust... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1212967f_716639.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212967f_716639.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!