Question: Which of the following isnota valid SQL statement? a. SELECT MIN (pubdate) FROM books GROUP BY category HAVING pubid = 4; b. SELECT MIN (pubdate)

Which of the following isnota valid SQL statement?
a. SELECT MIN (pubdate)

FROM books
GROUP BY category
HAVING pubid = 4;

b. SELECT MIN (pubdate)

FROM books
WHERE category = 'COOKING';

c. SELECT COUNT(*)

FROM orders
WHERE customer# = 1005;

d. SELECT MAX(COUNT (customer#))

FROM orders
GROUP BY customer#;

Step by Step Solution

3.51 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a SELECT MIN p... 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_60b8c121295cf_716636.pdf

180 KBs PDF File

Word file Icon

1803_60b8c121295cf_716636.docx

120 KBs Word File

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