Which of the following isnota valid SQL statement? a. SELECT MIN (pubdate) FROM books GROUP BY category

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)

FROM books
WHERE category = 'COOKING';

c. SELECT COUNT(*)

FROM orders
WHERE customer# = 1005;

d. SELECT MAX(COUNT (customer#))

FROM orders
GROUP BY customer#;

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: