Which of the following is a valid SELECT statement? a. SELECT AVG (retail-cost) FROM books GROUP BY

Question:

Which of the following is a valid SELECT statement?
a. SELECT AVG (retail-cost)

FROM books
GROUP BY category;

b. SELECT category, AVG (retail-cost)

FROM books;

c. SELECT category, AVG (retail-cost)

FROM books
WHERE AVG (retail-cost) > 8.56
GROUP BY category;

d. SELECT category, AVG (retail-cost) Profit

FROM books
GROUP BY category
HAVING profit > 8.56;

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: